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
You can use Connection String too. Code below will result the same.
SchemaZen.exe script --connectionString "server=.;database=db;Integrated Security=true;" --scriptDir c:\somedir
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.
