Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JJ
Starting Member
23 Posts |
 Posted - 2002-06-05 : 13:16:20
|
| Hi Guys, Has anybody here created an installation script for Sql Server?I want to create a script that will put MSDE 2 onto a machine. Anybody here do this sort of thing?Thanks In Advance,JJ |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-06-05 : 14:55:07
|
| This is how I did it before (With SQL Server though, not specifically MSDE). - Generate all the required scripts in Enterise Manager, and save them into one or more .SQL files, as needed. - Create .BAT files that call these .SQL files using OSQL.EXE (See BOL for OSQL input parameters). This assumes that client tools are installed on the machine where setup is being run. - Call these .BAT files from Installshield project, using the scripting interface. Installshield setup collects the server name, login, password etc. at run time and passes these as parameters to OSQL.EXE - Sometimes, you need to populate the tables with the required data. You can't generate scripts for existing data, in the form of INSERT statements. That's when I wrote a procedure that scripts existing data in the form of INSERT statements. You can download it from: http://vyaskn.tripod.com/code.htm#inserts--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
pattikay
Starting Member
36 Posts |
Posted - 2002-08-14 : 05:19:32
|
| Hi,I had the same problem and Vyas suggestion works fine.I have one question for Vyas though.InstallShield will take you to the Maintenance Setup Dialogwhen you run the program more than once.If you are to run the program again you have to go thru the Maintenance Setup Dialog.How do use setup without the Maintenance Setup Dialog?what do u do in your case?Edited by - pattikay on 08/14/2002 05:36:23 |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-08-22 : 05:06:03
|
| Sorry, I am not much of an Installshield expert :-)--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|
|
|
|
Installation Scripts