newer version of SQL Compare

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

newer version of SQL Compare

Postby yacov » Tue Sep 27, 2011 10:07 am

Hello
i want to write Dll that comper two snapshot files .
to genarate the SNP files im using Redgate's free tool SQL Snapper
when i load the files with C#
CustomerDB.LoadFromDisk(@"D:\\bcp\\YACOVR_SQLHASHAVIT.HashSQL.snp");

i get err "The database snapshot was saved by a newer version of SQL Compare"

please advice
Regards
yacov -R
yacov
 
Posts: 11
Joined: Tue Jun 29, 2010 4:46 pm

Postby Brian Donahue » Wed Sep 28, 2011 11:05 am

Hello Yacov,

I believe we have an existing support call about this that you submitted by email. Sounds like all you need to do is install the latest SQL Compare and grab the DLLs out of the installation folder. The SDK installation typically lags behind the rest of the Red Gate SQL Tools when it comes to releasing updates.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

newer version of SQL Compare

Postby yacov » Wed Sep 28, 2011 12:40 pm

Hello Brain
How i Get the latest version of SQL Compare
Regards yacov
Regards
yacov -R
yacov
 
Posts: 11
Joined: Tue Jun 29, 2010 4:46 pm

Postby Brian Donahue » Wed Sep 28, 2011 1:14 pm

Downloading the latest SQL Compare demo will get the binaries you need.

http://www.red-gate.com/products/sql-de ... l-compare/
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

version of SQL Compare

Postby yacov » Sun Oct 02, 2011 6:49 am

Hello Brian
Thank you for answer ,do you mean that i need to buy new version of sql comper
Regards
yacov -R
yacov
 
Posts: 11
Joined: Tue Jun 29, 2010 4:46 pm

Postby Brian Donahue » Mon Oct 03, 2011 10:17 am

If you're making snapshots from SQL Compare 9, you need the SQL Compare 9 binaries in the SDK to read it back. Problem is there is no v9 of the SDK, so you can't buy an upgrade at this point.

You may want to wait a few weeks until the SDK 9 upgrade is finished going through testing. There are a few problems at the moment with using the v9 binaries - first of all you have to get them from the SQL Data Compare distribution because SQL Compare is merging the engine into the executable and second, it's error-city when I try to compile the SQL Compare Engine code samples with the v9 engine.

Looks like it requires .NET 3.5 for a start, and also there are lots of compiler errors around the WriteToFile stuff: I would assume they've rearranged the API again there. If you want to give it a try with the SQL Data Compare version of engine, be my guest, but I don't have any answers at this point if your code doesn't compile any more.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

version of SQL Compare

Postby yacov » Mon Oct 03, 2011 10:32 am

Hello Brain
what i will do now ?
do you have snaper ver 7 ?
Regards
yacov -R
yacov
 
Posts: 11
Joined: Tue Jun 29, 2010 4:46 pm

Postby Brian Donahue » Mon Oct 03, 2011 10:51 am

If it were me and I was using Snapper I'd just write my own version of snapper using the SDK. Creating a snapshot is just a matter of registering the database and calling SaveToDisk(). This will also save you the trouble of this happening again because the release of SDK lags behind the other tools.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

version of SQL Compare

Postby yacov » Mon Oct 03, 2011 12:15 pm

Hi Brian
when i Do comper with two SNP files with comper.exe command line
I get the good result 'i get the coperison file
now i need work with sdk ,
Regards
yacov -R
yacov
 
Posts: 11
Joined: Tue Jun 29, 2010 4:46 pm


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests