Migration SQL Toolkit 6 to SQL Comparisson SDK 8

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Migration SQL Toolkit 6 to SQL Comparisson SDK 8

Postby ilya » Mon Jul 12, 2010 12:51 pm

We use SQL Toolkit 6 now (with SQL Compare 6 and SQL Data Compare 6) to synchronize databases (structure and data).
Structure update from a snapshot, and the data update from a database backup.

To be able to synchronize also SQL 2008 databases, we want to migrate to SQL Comparison SDK 8.

Is the new SDK compatible with Toolkit 6? Or it has another functions, another structure etc, so that our code can not be reused with the Comparison SDK?
ilya
 
Posts: 13
Joined: Wed Jul 30, 2008 9:28 am

Postby chriskelly » Tue Jul 13, 2010 3:12 pm

SQL Toolkit was renamed to "SQL Comparison SDK" because of the confusion caused between the SQL Toolkit product and the SQL Toolbelt product.

They should be fully compatible as they are essentially the same product. You can think of them as either SQL Comparison SDK version 6 & 8 or SQL Toolkit version 6 & 8.
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Re:

Postby ilya » Tue Jul 13, 2010 3:21 pm

chrisk5 wrote:They should be fully compatible as they are essentially the same product. You can think of them as either SQL Comparison SDK version 6 & 8 or SQL Toolkit version 6 & 8.


Thank you for the answer.

Generally, the fact, that it is the same product, gives no guarantee, that some functions have not been changed/updated/ removed in the new version. That's why I ask here.

So, our code, working with vers. 6, should also work with SDK 8?
ilya
 
Posts: 13
Joined: Wed Jul 30, 2008 9:28 am

Postby chriskelly » Tue Jul 13, 2010 3:23 pm

Yes it should, although it is true that there is no guarantee. If you do encounter any problems either refer to the forum posts or contact support@red-gate.com
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby ilya » Tue Dec 21, 2010 3:19 pm

Hello again, I've started to migrate our code to use the SDK 8.0.
And by data compare with backup I get the Exception "Cannot load the Backup Reader dll!" (also in your sample project)
Call stack:
bei U.a()
bei RedGate.SQLCompare.Engine.ReadFromBackup.BackupSetDatabase.GetBackupSets(IList`1 filePaths, IList`1 passwords)
bei SQLDataCompareCodeSnippets.BackupComparisonExample.RunExample() in D:\\Kuznetsov\\Samples\\Automating SQL Data Compare\\C#\\BackupComparisonExample.cs:Zeile 31.
bei SQLDataCompareCodeSnippets.Program.Main() in D:\\Kuznetsov\\Samples\\Automating SQL Data Compare\\C#\\Program.cs:Zeile 103.
bei System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
bei Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
bei System.Threading.ThreadHelper.ThreadStart()

The reference to the RedGate.BackupReader has been added (and if not, I would be not able to compile it)

Any Ideas?
ilya
 
Posts: 13
Joined: Wed Jul 30, 2008 9:28 am

Postby ilya » Thu Dec 23, 2010 12:20 pm

The problem with the exception "Cannot load Backup Reader dll!" solved:

http://www.red-gate.com/MessageBoard/vi ... hp?t=12450
ilya
 
Posts: 13
Joined: Wed Jul 30, 2008 9:28 am

Postby chriskelly » Thu Dec 23, 2010 1:05 pm

Good to hear that you have solved your problem.
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests