Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Best way to generate DDL and data insert scripts

There is no easy or best way, but few options are available such as DMO or SMO or even using Enterprise Manager for SQL 2000 or SS Management Studio for SQL 2005.

Look for DBPublish wizard tool in this case that will help quite a bit and also you can take help of Tibor's and  Vyas's code snippets in this case.


 

Posted: Monday, June 11, 2007 6:53 AM by SQL Master

Comments

SSQA - SqlServer-QA.net said:

There is no easy or best way, but few options are available such as DMO or SMO or even using Enterprise

# June 11, 2007 10:14 AM
Anonymous comments are disabled