How can we help you today? How can we help you today?

cannot Compare/Deploy data from source control?

Is there a way to compare data from a database to Source control?

When I go to Show History and pick a version that has data changes. I do not have the option to compare with DataCompare; only Compare Pro.

Same goes for If I right click on a database and select Data Compare/Deply I do not have the source control options that I have with Schema Compare/Deploy
chattabaugh
0

Comments

2 comments

Sort by
  • troyhunt
    According to the features list, you'll need to go pro in order to compare against a folder of scripts from VCS: http://www.red-gate.com/products/sql-de ... e/features
    troyhunt
    0
  • David Atkinson
    SQL Data Compare Pro can't yet deploy from SSMS in the same way as SQL Compare Pro does currently. This is because we haven't yet released SQL Source Control with data support except in early access, and therefore haven't yet implemented the integration.

    To deploy currently you will need to "get" the scripts folder to a working folder on your hard disk, and simply use SQL Data Compare Pro on this.

    David Atkinson
    Red Gate Software
    David Atkinson
    0

Add comment

Please sign in to leave a comment.