.SCP files & table selection

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

.SCP files & table selection

Postby slam » Tue Jun 30, 2009 2:36 pm

I have a .SCP file saved from SQL Compare 8.0 which I have table selections in it. I am trying the synchronise the structure based on those selections.

I am using the RedGate.SQLCompare.Engine.Project class to load the file, but I can not find anywhere in the Project class where it might give me the selections.

Can anyone provide some examples on how to use the RedGate.SQLCompare.Engine.Project class to synchronize the database based on the selections from the project.

Please note, I have tried using the RedGate.SQLDataCompare.Engine.Project class where the ReplayUserAction Method is there, but it doesn't understand my project file, and I am also assuming that the project file that it is looking for is SQL Data Compare specific.

I am also using the DLL's found in the SQLCompare folder of the installation because it has parser messages.
slam
 
Posts: 3
Joined: Tue Jun 30, 2009 2:27 pm

Feature Request

Postby slam » Thu Jul 02, 2009 8:47 am

The feature tacking code is SC-4506.

If you want this feature, please post here. :D
slam
 
Posts: 3
Joined: Tue Jun 30, 2009 2:27 pm

Work around

Postby slam » Thu Jul 02, 2009 12:38 pm

for the time being, I've had to use an xml file with the table selections and use the Ddifference class to achieve what I want. You can read about it here.

http://www.samlam.eu/2009/07/sql-compare-sdk-with-2-script-folders.html
slam
 
Posts: 3
Joined: Tue Jun 30, 2009 2:27 pm


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests