SSC History launches SDC without project settings

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, andy.campbell.smith

SSC History launches SDC without project settings

Postby isme » Thu Nov 28, 2013 12:43 pm

Hey RG,

SQL Source Control's History function launches SQL Data Compare without any project settings. (version 3.5.3.29).

We find the History function useful for testing migration scripts. It would be great if you could fix this little thing to make it easier for us to test things.

To show you what I mean I'll walk through how to sync my database to test a migration from revision 20124 to 20130.

Select revision with History UI

Revision 20124 is selected in the History.

First I'll sync the schema then the data using the highlighted buttons.

Image

Sync schema with SQL Compare

I click the blue button in the History to launch SQL Compare.

It launches with project settings that match the History UI: the same VCS, the same revision, the same target database.

Image

In SQL Compare I just click 'Compare Now' and then go to the Deployment Wizard. Easy!

Sync data with SQL Data Compare

I go back to the History UI and click the red button to launch SQL Data Compare.

It launches with a clean slate. Before I can sync the data, I have to set up the project myself. Not taxing, but tedious.

Image

Can you make SQL Source Control pass the correct project settings to SQL Data Compare?

Thanks!
Iain Elder, Skyscanner
isme
 
Posts: 81
Joined: Tue Jun 12, 2012 1:49 pm
Location: Edinburgh

Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests