generating database script

  • Thread starter Thread starter Ollie Riches
  • Start date Start date
O

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
 
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

Miha Markic said:
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

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

Cheers

Ollie Riches
Click to expand...
Click to expand...
 
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/


Ollie Riches said:
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

Miha Markic said:
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

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

Cheers

Ollie Riches
Click to expand...
Click to expand...
Click to expand...
 
thanks

Ollie

Tibor Karaszi said:
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/


Ollie Riches said:
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

Miha Markic said:
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
Click to expand...
Click to expand...
Click to expand...
 
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/
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Database Data 2
What are the steps to fix damaged MDF files in SQL Server? 0
Generate a database from XSD? 2
Can we create database tables/script from DataSet 2
RAD and Code Generators 1
Save a database including all data to a SQL text file 4
ARITHABORT.... 6
Running SQL script through VB windows installer 1

Back
Top