This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- SQL Database Best Practices
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 25, 2009
07:29 PM
SQL Database Best Practices
Can someone please tell me what the best practice is for SQL database distribution and uninstallation?
Currently our installer deploys a database, runs some sql scripts and the application deployed uses this database. Common scenario I'm sure.
When the user chooses to uninstall our product, I backup and then drop the database. There is still a copy of the database (via backup file) should the user decide they need to see the data again. Is this correct procedure, or should the uninstall leave the database on their system?
Can someone tell me if I am following best practice, or where I can read best practice for this scenario?
Currently our installer deploys a database, runs some sql scripts and the application deployed uses this database. Common scenario I'm sure.
When the user chooses to uninstall our product, I backup and then drop the database. There is still a copy of the database (via backup file) should the user decide they need to see the data again. Is this correct procedure, or should the uninstall leave the database on their system?
Can someone tell me if I am following best practice, or where I can read best practice for this scenario?
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 13, 2009
01:03 AM
Surely someone knows the MSI standards ?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 24, 2017
05:02 AM
Am having this error on my server
Practice Assistant Task Manager
Unknown database
Alias:dbPAMgr.
Practice Assistant Task Manager
Unknown database
Alias:dbPAMgr.