DataBase Installer

[Jon Vaughan]

Whats the best way to install a database as part of a server side install
package. The package will install all the webservices and then im looking
for it to install a database ( sql server - sql express 2005 to be
precise ). it will need to include tables , stored procedures, triggers,
initial data, relationships etc.

Is tehre a best practice for this or even some examples ?

Thanks

 

[Jon Vaughan]

What would be even better if it could :

1.) Install the webservices
2.) Install SQL Express 2005
3.) Setup the Database

 

[Jon Vaughan]

Sorry to keep adding parts :

The database will be quite large in size if scripted and im using VS.Net
2003