Skip SQL db uninstall on patch or update

[camberman]

I was sooo close to buying this, but when testing patches and updates, I found that they uninstalled my test database and all its data when executing a patch or major upgrade. This happened even if I totally removed the sql connection information from the upgrade/patch project.

That is completely unacceptable for a patch/upgrade to remove an existing db that was installed with the original project. I realize that it happens as part of the uninstall of the prior version if it was part of the project to run a db creation script, but kinda hard to upgrade a program if you can't retain db data.

I suppose I "might" be able to force a db backup, then a restore after the new install, but that's nothing more than a hack, especially if I need to alter tables, etc.

[Dan]

Hello and welcome to Advanced Installer forums,

Thank you for your interest in Advanced Installer.

If you're looking to preserve the old database files during upgrade, here's the How do I prevent a file or registry entry from being uninstalled or repaired? article which may be useful.

Please let us know if that helped otherwise give us more details.

Best regards,
Dan

[camberman]

Thanks. I think I may have found a work-around, as this was installed via a pre-query and a script. I think I may be able to remove the pre-query and see if that preserves the db. If so, I'll update this post.