Awesome Open Source
Awesome Open Source

Schema Zen - Script and create SQL Server objects quickly

Schema Zen has three main commands:

script

SchemaZen.exe script --server localhost --database db --scriptDir c:\somedir

This will generate sql scripts for all objects in the database in a directory structure that looks something like:

c:\somedir\
	data
	foreign_keys
	procedures
	tables
	views
	props.sql
	schemas.sql

create

SchemaZen.exe create --server localhost --database db --scriptDir c:\somedir

This will create a database named db from the sql scripts in c:\somedir.

compare

SchemaZen.exe compare --source "server=dev;database=db" --target "server=qa;database=db" --outFile diff.sql

This will compare the databases named db between dev and qa and create a sql script called diff.sql that can be run on qa to make it's schema identical to dev.

See SchemaZen.exe help [command] for more information and options on each command.



Download

The latest release can be downloaded here

Contributing

Pull requests are welcome and appreciated. See contributing.md for guidelines.

Chat

Join the chat at https://gitter.im/sethreno/schemazen


If you've found Schema Zen helpful you can buy me a coffee to say thanks. Cheers!


Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
c-sharp (12,453
database (1,239
schema (178
mssql (49
version-control (47