Is there any inbuilt store proc / any database program by which I can generate all the database object script(like stored procs, triggers, functions, tables etc.) from a particular database.
I am using SQL SERVER 2005 + 2008
Thanks in advance
views:
42answers:
3
A:
In Object Explorer in Microsoft Server Management Studio rightclick on the database and select Tasks -> Generate Script and then follow the guide...
Joakim Backman
2009-12-04 10:22:31
I clearly wrote that I need to do the work using some spored procs and not by using SSMS tools
priyanka.sarkar
2009-12-04 10:28:33
for not reading the question properly
adolf garlic
2009-12-04 11:14:12
Sorry, I just read "any database program" not the title
Joakim Backman
2009-12-04 12:09:45
it's ok.. we all make mistake (:
priyanka.sarkar
2009-12-04 12:23:12
A:
from .net http://www.sqlteam.com/article/scripting-database-objects-using-smo-updated
from powershell http://www.mssqltips.com/tip.asp?tip=1745
sqlcmd http://www.edumax.com/microsoft-sql-server-the-sqlcmd-tool-and-sql-server-management-objects.html
adolf garlic
2009-12-04 11:21:07
+1
A:
SSMS itself uses SMO, namely the Scripter class. You can use SMO from any .Net application to extract scripts yourself.
Remus Rusanu
2009-12-04 19:04:26