Delete database if it exists....

splitpetesplitpete Posts: 8
edited August 26, 2010 6:07AM in SQL Packager Previous Versions
Hi,

I would like to create an exe that installs a database. I am able to do that easily enough. However, if the database already exists on the specified machine, I want the existing database to be deleted and the new version to be installed in its place.

I attempted to do this by creating a script and inserting the appropriate code to perform the delete in the script and then creating an exe from that script. This does not work. The exe tells me there is already a database by that name and won't continue until I provide a different one. I know it has not reached the script at this point.

Is there a way to do this?

Thanks in advance

-splitpete
Sign In or Register to comment.