Create a database on installation

I have an add on app that is almost ready for distribution. I am trying to use Visual Studio Installer 1.1 to install the app and create a small database on MS SQL Server 2000.

The SQL Server 2000 client already exists on the target and we want to be able to run some sort of script or small app to create the database and tables.

I have been unable to find any sort of information on how to accomplish this. Can some some briefly explain the steps needed and/or point me to some useful information. Any help will be greatly appriciated.

Just generate a script file from SQL server then run it against the new server...

You can do it all in one script.

First create the database.

Then create your desired tables.

Then put the relations between them tables.

All this can be done in a scriptfile, which you can run from VB

Sounds simple, however from where should I run the script? Does VSI have a mechanism for this or do I create a small VB app that VSI will run?

I apologize, but I have not been able to find any goos documentation on VSI that even hints at this sort of thing.

From SQL Server Enterprise Manager select table (or any other object) and right click on it. Select All Tasks > Generate SQL Scripts from dropdown menu. Select Script All Objects on the General tab and click OK. This may take awhile so you better do this overnight. File will be created afterwords. Include that file in the distribution and when program initially runs load entire file into a string variable and excute it via ADODB.Connection.Execute

Or you may simply send that file to the other party for manual execution.

Thank you McGenius, Swatty and Leather, you have given me a plan of attack.

Thanks again for your time.