I wrote a stored procedure to script out database objects (functions, stored procedures, constraints, jobs) from SQL Server 2005 or SQL Server 2000. We use this at our agency for automated source control comparisons. The procedure uses DMO and is extremely fast.
Feel free to email me if you have any questions.
Here is the source code
Tuesday, March 13, 2007
Scripting Objects from SQL Server 2005 or SQL Server 2000 Using DMO
Posted by Dustin W. Jones at 1:00 PM
Labels: Journal, SQL Server
Subscribe to:
Post Comments (Atom)

0 Comments:
Post a Comment