Script

[DayWalker]

I spose this is more a SQL question but maybe someone can help out. I want to deploy a windows application at a clients office. The app queries a SQL db. I have created the db for the client but i want to give it to them as a autoexecuting script that they can run on there server. Is this possible or do i have to generate the normal script and run it in Query Analyser??

[Nerseus]

Traditionally, I've given clients one of the following :

1. SQL script that they must run in manually (db.sql or similar)

2. I call out to isql.exe (or osql.exe?) during a setup

3. Custom code to create a DB through COM (SQLDMO I think).

4. A database backup of a stripped down version of the DB.

 

Number 4 works great if you have some system look tables that need to get in. I prefer number 2 but I use a custom built setup application. Since this is a one time thing usually (creating the DB), you can always put it in as part of the setup notes assuming your clients read them (or better yet, YOU do the installs).

 

If they're savvy enough to use Query Analyzer, a simple script would work but if you don't have any system tables, you could have them use Enterprise Manager to create the DB with all the defaults.

 

Using a script has issues since you'll have to specify a local path (C:\MSSQL\...) for the DB and Log files.

 

-Nerseus

[DayWalker]

Great thanks for the help i never actually thought of 2 & 4. I will give it a bash