MS SQL Server 7.0 Installs

[swdevlin]

My installer needs to create a database and tables on an existing SQL Server. I also need to populate the database with sample data. I have already created the SQL script and the bcp files. I guess all I need to do is hook into SQL Server and get it to process those files.

Has anyone done this with Setup Factory? If so, care to share some tips? :-)

[DanielB]

Re: MS SQL Server 7.0 Installs

I.m in something simillar but with SLQ 2000, I need to make setup factory to run a .SLQ file (query) that create the database

[shankar]

Re: MS SQL Server 7.0 Installs

As of now Setup Factory doesnot provide such facility to manipulate the databases.U hav to depend on VB/VC++ exe application

[Jason Pate]

Re: MS SQL Server 7.0 Installs

I have just started experminanting with Setup Factory and MSDE (msde is simply SQL stripped down to the basics) MSDE has a utility names osql, I use the fallowing command line to install my database on MSDE

%SysDrv%\MSSQL7\binn\osql /U sa /P /i "%SrcDir%\SQL\7.0\Install Scripts\SrvInst63.sql"

If OSQL program work on SQL 7 this should work for you,
It gives the path to osql the /u for user id ("sa" for my needs) /p is the password (mine is null) I forget what the /i does but I think its has to do with the fact that the SQL script file is not, it all CASE SENATIVE!!!!! and Srcinst62.sql is the script for creating my db file see how that works for you.