Script out objects for a specific schema

JonasGJonasG Posts: 11 Bronze 1
Hi!
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),
  1. I make a copy of the file
  2. Open that and do [Compare Now]
  3. Edit Filter
  4. For "All objects types in all schemas" Include if: Schema name Equals "MySchemaName"
  5. I Save the project
There is no objects selected, and the deploy file is empty!

Filter tree

Filter dialog


How do I configure the SQL Compare(.scp)-file to only deploy objects for a specific schema(s)?




Best Answer

  • JonasGJonasG Posts: 11 Bronze 1
    Accepted Answer
    Did a retake, know it works.
    A new copy and carefully only select Custom filter rules....  And know the correct number of objects is selected. May be is was that I changed the Schema node first, and the restore failed some how?

Sign In or Register to comment.