SchemaZen.exe script -c "server=localhost;database=db;trusted_connection=yes;" --scriptPath c:\somedir\script.sql
This will generate an sql script that creates objects in the database in the specified path:
c:\somedir\
script.sql
The script's routines (procedures, functions etc) are generated by their dependency order, so you should be able to just run the script on an empty database and it will take care of everything. You can cancel this options by the --no-depends flag to make it load faster
Another added option, is to specify which object types to script from the below list:
[user_defined_types, tables, foreign_keys, assemblies, functions, procedures, triggers, views, xmlschemacollections, data, roles, users, synonyms, table_types, schemas, props, permissions, check_constraints, defaults, routines]
Use it like: --onlyTypes users,tables
If empty, includes all
SchemaZen.exe create -c "server=localhost;database=db;trusted_connection=yes;" --scriptPath c:\somedir\script.sql
This will create a database named db from the sql scripts in c:\somedir\script.sql
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.
Another added option, is to specify which object types to script from the below list:
[user_defined_types, tables, foreign_keys, assemblies, functions, procedures, triggers, views, xmlschemacollections, data, roles, users, synonyms, table_types, schemas, props, permissions, check_constraints, defaults, routines]
Use it like: --onlyTypes users,tables
If empty, includes all
SchemaZen.exe export -c "server=localhost;database=db;trusted_connection=yes;" --exportDir c:\somedir
This will export the data from the database to c:\somedir\data
SchemaZen.exe import -c "server=localhost;database=db;trusted_connection=yes;" --importDir c:\somedir
This will import the data from the folder c:\somedir\data to the database
See SchemaZen.exe help [command] for more information and options on each command.
This project was meant to work with SSDT but without using their deployment system to enable more flexibility over the migrations.
You would need an additional library like DbUp or so. PS scripts will be added in the future to support this functionality.
The idea is, to do changes via SSDT (for example alter a stored procedure) and then run a command in the PM Console to generate a script from the changes.
I Like to remove all the routines (stored procedures, views, functions etc) pre-migration and append them post-migration so they will only appear once in the migration process and to solve dependency issues (for example a procedure that references a table type).
An example usage project will be added in the future.
Pull requests are welcome and appreciated. See contributing.md for guidelines.
I forked this repo from sethreno/schemazen.
This was an amazing project, but it is a bit unmaintaned in the last couple of years.
I added and changed some functionality as I needed, and shared it here in case someone would also be interested in that.
I don't like the coding style so much, so I might change it in the future to a more appropriate one, although currently I have no time for that.
You are welcome to try it, tell me if it needs additional features or has bugs, and send pull requests.