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
SchemaZen.exe create --server localhost --database db --scriptDir c:\somedir
This will create a database named db from the sql scripts in c:\somedir.
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.
The latest release can be downloaded here
Pull requests are welcome and appreciated. See contributing.md for guidelines.
If you've found Schema Zen helpful you can buy me a coffee to say thanks. Cheers!