I am new to AI and trying to figure one final part. During the install, I create a MSSQL Db. I can get everything to work fine on first install. However, I can't figure out how to handle the case when the application is uninstalled and reinstalled. I don't want to drop the db on uninstall. When reinstalling, it fails because the tables already exist in the db. I can add an if exists to every table in the script but there is a large number of tables and it does not seem like the best approach. Ideally, I would like a way to skip executing the SQL script file if the database already exists. I can't seem to find any information on how to do this. Any ideas?
Thanks
FOLLOW US
Get the latest news in Application Packaging