cannot Compare/Deploy data from source control?

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

cannot Compare/Deploy data from source control?

Postby chattabaugh » Mon Feb 14, 2011 11:09 pm

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
 
Posts: 7
Joined: Mon May 08, 2006 10:02 pm

You need to go pro

Postby troyhunt » Tue Feb 15, 2011 8:33 pm

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
 
Posts: 15
Joined: Sun Nov 28, 2010 3:36 am
Location: Australia

Postby David Atkinson » Tue Feb 15, 2011 9:05 pm

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 2 EAP

Who is online

Users browsing this forum: No registered users and 0 guests