Size:
1.81MB
Requirements:
.NET Framework 2.0 or higher
.NET Framework 2.0 or higher
Price:
Free
Free
System:
Windows 2003/XP/2000/98/Me
Windows 2003/XP/2000/98/Me
Rating:
4.4
4.4
License:
Freeware
Freeware
Description - SMOscript - provides a tool called scptxfr which generates DROP and CREATE scripts
SQL Server 2000 provides a tool called scptxfr which generates DROP and Create scripts for all objects in a database. Since it is not included in the latest SQL Server versions, I developed a replacement for scptxfr which uses the .Net SMO libraries for script generation called SMOscript. The SMOscript utility implements the following functions: * list all databases on a server * list all objects in a database * script CREATE or DROP Statements for each object in database