Installing database MSI - drop database
Hi,
I have development a Wise Installer MSI to create a database, it runs a long transact SQL script as a SQL Scripts Action. This SQL creates a database and populates it with table and view on those tables. Fine.
But when I unistall, it leaves the database behind. I would like to uninstall to drop the database.
I watched your video on custom actions, and I believe I can write a Windows App to connect and drop the database when uninstall is requested.
If this the best solution to dropping the database ? Or is there a better cleaner way to to it?
thanks, Adrian
I have development a Wise Installer MSI to create a database, it runs a long transact SQL script as a SQL Scripts Action. This SQL creates a database and populates it with table and view on those tables. Fine.
But when I unistall, it leaves the database behind. I would like to uninstall to drop the database.
I watched your video on custom actions, and I believe I can write a Windows App to connect and drop the database when uninstall is requested.
If this the best solution to dropping the database ? Or is there a better cleaner way to to it?
thanks, Adrian
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
anonymous_9363
15 years ago
You won't need to develop an application to do this: surely a simple SQL script executed with OSQL (or whatever the database client's query tool is called) will suffice? http://sqlserver2000.databases.aspfaq.com/how-do-i-drop-a-sql-server-database.html
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
