Options

Using SQL Change Automation project with sql compare

JeromeLJeromeL Posts: 10 Bronze 4
in SQL Change Automation
Should I be able to use SQL Compare with a SQL Change Automation project? It looks like SQL Compare opens the schema but when comparing, it shows me only differences, as if the schema was empty.

Thanks
Tagged:
· Share on Twitter

Best Answer

  • Options
    way0utwestway0utwest Posts: 313 Rose Gold 1
    Answer ✓
    No, the SCA projects really use the migration scripts. The set of schema items is really for you to view, but the changes are in the migrations. If you make simple schema changes, this might work, but I think there are some missing items that preclude this.

    I'll ask the question, but I think the idea is that this won't quite work.
    Editor, SQLServerCentral
    · Share on Twitter
Sign In or Register to comment.