I have a database with thousands of stored procedures, functions, tables, and views and I'd like to dump all of the code out to individual files. I know you can reverse engineer the code within Enterprise Manager and Query Analyzer but it seems you can only do it one object at a time. Is there any code or utility out there that will allow me to dump all of the function/procedure/table/view definitions out to a file on the file system? By the way, I'm using SQL Server 2000.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Dumping stored code and ddl to files
- Thread starter gharabed
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
The Enterprise Manager script database feature will do all objects at once. Right click on the database and select all tasks, then script database. You can then add in all the objects you want included.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question