By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 1,436 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

Build SQL database during installation

P: n/a
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
Nov 15 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"pcPirate" <ph****@hotmail.com> wrote in news:OLaICXdpDHA.1408
@TK2MSFTNGP11.phx.gbl:
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------
Nov 15 '05 #2

P: n/a
Thanks, but do you have any example? Maybe an appropriate website?

pcPirate
"Peter Koen" <koen-newsreply&snusnu.at> wrote in message
news:eN**************@TK2MSFTNGP09.phx.gbl...
"pcPirate" <ph****@hotmail.com> wrote in news:OLaICXdpDHA.1408
@TK2MSFTNGP11.phx.gbl:
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------

Nov 15 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.