generating database script

[Ollie Riches]

Is it possible to generate the t-sql script for a database schema and the
data from .Net(C#) at all?

Cheers

Ollie Riches

 

[Ollie Riches]

found this so far

http://www.sqlteam.com/item.asp?ItemID=17320

 

[Miha Markic [MVP C#]]

Check out also free tool CodeSmith at www.ericjsmith.net/codesmith

 

[Ollie Riches]

thanks but I don't want a code generator, I am looking for a programmatic
approach to scripting out the database schema and the dat contained in the
database, just like you can through sql server 2000 enterprise manager

Cheers

Ollie Riches

Check out also free tool CodeSmith at www.ericjsmith.net/codesmith

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

Is it possible to generate the t-sql script for a database schema and the
data from .Net(C#) at all?

Cheers

Ollie Riches

 

[Tibor Karaszi]

The only accessible code I know of for this is in DMO, which is a COM based API. You can find a tiny
(classical VB) example here, among other things:
http://www.karaszi.com/SQLServer/info_generate_script.asp

With 2005, we can use SMO for this, which is managed code.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/

thanks but I don't want a code generator, I am looking for a programmatic
approach to scripting out the database schema and the dat contained in the
database, just like you can through sql server 2000 enterprise manager

Cheers

Ollie Riches

Check out also free tool CodeSmith at www.ericjsmith.net/codesmith

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

Is it possible to generate the t-sql script for a database schema and the
data from .Net(C#) at all?

Cheers

Ollie Riches

 

[Ollie Riches]

thanks

Ollie

The only accessible code I know of for this is in DMO, which is a COM based API. You can find a tiny
(classical VB) example here, among other things:
http://www.karaszi.com/SQLServer/info_generate_script.asp

With 2005, we can use SMO for this, which is managed code.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/

thanks but I don't want a code generator, I am looking for a programmatic
approach to scripting out the database schema and the dat contained in the
database, just like you can through sql server 2000 enterprise manager

Cheers

Ollie Riches

Check out also free tool CodeSmith at www.ericjsmith.net/codesmith

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

Is it possible to generate the t-sql script for a database schema and the
data from .Net(C#) at all?

Cheers

Ollie Riches

 

[Sahil Malik]

Ollie,

Not quite.

You can most certainly write a bunch of queries to read the master db and
peice the info together, and you can leverage on the FillSchema methods, but
ADO.NET is not a schema/script generator.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/