BAT: SchemaZen samples for export and import

1 post / 0 new
benzzon
benzzon's picture
BAT: SchemaZen samples for export and import

*** SchemaZen-command to script database-objects, and export all table-data:
SchemaZen.exe script -s [sql_srv] -b [dbname] -u [sql_user] -p [sql_passwd] --dataTablesPattern=.* -d c:\schemazen_data

*** SchemaZen-command to import data (creates new database)
SchemaZen.exe create -s [sql_srv] -b [dbname] -u [sql_user] -p [sql_passwd] -d c:\schemazen_data