Red Gate forums :: View topic - Database snapshot was saved by newer version of SQL Compare
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

Database snapshot was saved by newer version of SQL Compare

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
connectx



Joined: 29 Aug 2012
Posts: 2

PostPosted: Wed Aug 29, 2012 3:08 am    Post subject: Database snapshot was saved by newer version of SQL Compare Reply with quote

I downloaded the latest SQLToolkit installer (ver 1.8.2.238) this morning. I rebuilt my laptop over the weekend and don't have an earlier version of the RG tools installed.

I used SQL Compare (10.2.0.1337) to generate a snapshot of my SQL 2008 R2 database. I am using this snapshot along with the SQL Compare SDK to synchronize my databases. I have been using the same sync program for a couple of years now. The only thing that changes in it is the snapshot.

I used to have an earlier version of the RG tools from a couple of months ago installed and referenced by my sync project. I have removed and re-added the references to the RG assemblies.

Everything builds successfully. Everything appears to function normally when I run the sync program. By when I actually begin to execute the sdk code I get an error. The error message is: "The database snapshot was saved by a newer version of SQL Compare". The error occurs during a call to RedGate.SQLCompare.Engine.Database.LoadFromStream(). I have included the full exception message below.

Looking through the forums for SQL Compare, I see that some patches were released earlier this month and I'm wondering if this is the cause of the mismatch.

Here are the assembly versions from the \SQL Comparison SDK 10\Assemblies\SQL Compare install folder:

RedGate.Shared.SQL.dll, 9.5.0.440
RedGate.Shared.Utils.dll, 9.5.0.440
RedGate.SQLCompare.ASTParser.dll, 10.0.0.192
RedGate.SQLCompare.Engine.dll, 10.0.0.192
RedGate.SQLCompare.Rewriter.dll, 10.0.0.192

==================================================
Full exception detail:

System.ApplicationException was unhandled
HResult=-2146232832
Message=The database snapshot was saved by a newer version of SQL Compare
Source=RedGate.SQLCompare.Engine
StackTrace:
at RedGate.SQLCompare.Engine.Database.LoadFromStream(Stream #a0, Database #uwL)
at RedGate.SQLCompare.Engine.Database.LoadFromStream(Stream f)
at ChartX.Configurator.Form1.SynchronizeDatabaseWithSnapshot() in c:\Projects\ChartX\ChartX.Configurator\Form1.cs:line 343
at ChartX.Configurator.Form1.btnOpenDatabase_Click(Object sender, EventArgs e) in c:\Projects\ChartX\ChartX.Configurator\Form1.cs:line 295
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at ChartX.Configurator.Program.Main() in c:\Projects\ChartX\ChartX.Configurator\Program.cs:line 18
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:

===============================================

Hopefully someone has a suggestion for me. I need to get updates out to my clients in the next few days and not being able to synchronize the database schemas using this tool means I have a lot of tedious manual work to do.

Thanks
Robert Johnson
ConnectX Healthware, LLC
Back to top
View user's profile Send private message
connectx



Joined: 29 Aug 2012
Posts: 2

PostPosted: Wed Aug 29, 2012 5:58 pm    Post subject: Talked to RG support and have an answer Reply with quote

In case anyone else has the same issue as I reported earlierm, I have spoken to RG support. The problem is that currently the SQL Compare uses a newer version of the code than the SDK does. Until the SDK is updated to use the same dll's and newer code this error will continue.

The resolution, at least for now, is to continue using the older version of SQL Compare to build the snapshots. As long as the version of SQL Compare is older than the SDK version it appears to work fine.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group