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]

Re: Build SQL database during installation

"pcPirate" <phoon_@hotmail .com> wrote in news:OLaICXdpDH A.1408
@TK2MSFTNGP11.p hx.gbl:
[color=blue]
> 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
>
>
>[/color]

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]

Re: Build SQL database during installation

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

pcPirate


"Peter Koen" <koen-newsreply&snusn u.at> wrote in message
news:eNjvzRepDH A.2584@TK2MSFTN GP09.phx.gbl...[color=blue]
> "pcPirate" <phoon_@hotmail .com> wrote in news:OLaICXdpDH A.1408
> @TK2MSFTNGP11.p hx.gbl:
>[color=green]
> > 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
> >
> >
> >[/color]
>
> 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------[/color]