Script out objects for a specific schema
I'm using SQL Compare(.scp) file, to compare our repository to a release database. We add/update reports in different schemas, and I want to script out a deploy-script only for a list of schemas. The .scp-file is used by SQLCompare.exe.
In the SQL Compare(.scp) file, (that I use now),
- I make a copy of the file
- Open that and do [Compare Now]
- Edit Filter
- For "All objects types in all schemas" Include if: Schema name Equals "MySchemaName"
- I Save the project
There is no objects selected, and the deploy file is empty!
How do I configure the SQL Compare(.scp)-file to only deploy objects for a specific schema(s)?
0 · Share on Twitter