I’ve been wanting to creating something like this for myself for a while. A simple tool to quickly create a backup copy of a SQL Server database ‘structure’ (or schema if you will). It is really a simple command line tool that simply takes a few parameters like server\instance name, database, output directory and a prefix name for the output files.
It creates separate files for Tables, Views and Stored procedures (which includes UDFs)
Example usage:
SQLScripter.exe <-s:server> <-d:database> [-od:outputDirectory] [-p:prefixFileName]
Grab it here (plain exe in a zip file). It make use of the .Net 4.0 client framework.
0 Comments.