We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

camberman
Posts: 2
Joined: Sun Dec 08, 2013 4:00 pm

Skip SQL db uninstall on patch or update

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
Posts: 4530
Joined: Wed Apr 24, 2013 3:51 pm

Re: Skip SQL db uninstall on patch or update

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
Dan Ghiorghita - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
camberman
Posts: 2
Joined: Sun Dec 08, 2013 4:00 pm

Re: Skip SQL db uninstall on patch or update

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.

Return to “Feature Requests”