Advise on installing Database

  • Thread starter Thread starter Tim Marsden
  • Start date Start date
T

Tim Marsden

Hello

Your advise please,
What is the best way to install an application's SQL Server database using
the .NET installer.
Do I use a SQL script?
How do I generate the script? (The database must include the intial system
data)

Thanks
Tim
 
Hi,
I'm new for vb.net but normally the sql script works very well.
To generate one you can do with the SQLServer Enterprise Manager clicking
with the right button on the database name and selecting All activities ->
generate SQL script.
To generate the script for the tables rows (the one you said that are
initial data) you can write the insert statement or use some tool that allow
it (see Embarcadero site)
I hope this will be usefull for you.
Regards
Valeria
 
Hi Tim,

What do you mean by "(The database must include the intial system data)"?
If you mean the Master database, it will be there when you install the SQL
server.
If you mean the data in the table you want to deploy, I agree with
Valeria's suggestion.

You may take a look at the link below.(a helpful SP)
http://vyaskn.tripod.com/code.htm
Procedure to script your data (to generate INSERT statements from the
existing data)


Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Hi Tim,

To let Felix not alone (not because Valerie's answer is not good) I agree
with Felix because the way described in the example is very easy to deploy
and to maintain

Cor
 
Back
Top