Build SQL database during installation

[pcPirate]

Hi,

i) Is it possible to build the SQL database structure during the
installation of a C# applicaton? If yes, how?

Pls advice and thanks in advance

pcPirate

 

[Peter Koen]

Hi,

i) Is it possible to build the SQL database structure during the
installation of a C# applicaton? If yes, how?

Pls advice and thanks in advance

pcPirate

Yes it is.
Just connect to the master database of your database server and then start
a script similar to this one:

CREATE DATABASE newDatabase .....(lots of parameters here)

Use newDatabase
GO

CREATE TABLE .....
GO
CREATE TABLE .....
GO
CREATE VIEW .....
GO



--
------ooo---OOO---ooo------

Peter Koen - www.kema.at
MCAD CAI/RS CASE/RS IAT

------ooo---OOO---ooo------

 

[pcPirate]

Thanks, but do you have any example? Maybe an appropriate website?

pcPirate