Thank you for your reply. Per your advice, I attempted the same comparison using SQL Data Compare 10.4. This worked correctly for both emulating WidgetDev->WidgetLive comparison, as well as my own situation.
Here are the steps to reproduce the failure in the example included in SQL Comparison SDK 1.5:
1. Install SQL Comparison SDK 10 (10.5.0.7)
2. Open "C:\\Program Files (x86)\\Red Gate\\SQL Comparison SDK 10\\GettingStarted.exe" and click "SQL creation script for sample databases"
3. Logged in under an administrative account, run the supplied script on SQL Server (for reference, I have tried this on SQL Server 2008 (10.0.2531) and SSDT's LocalDB (11.0.3000))
4. Open the C# SQL Data Compare API samples folder from the GettingStarted.exe
5. Open Visual Studio 2008 as an Administrator (so it has write access to the installation folder)
6. Open "SQLDataCompareCodeSnippets.csproj" in the newly opened Visual Studio instance.
7. Edit Program.cs, changing the DevServerName and LiveServerName to the server from step 3.
8. Run the example program.
9. Run option c) Backup Comparison.
Here is where the first problem occurs. A DllNotFound exception is thrown on line 37 of BackupComparisonExample.cs:
- Code: Select all
Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
I worked around this by grabbing version 184.108.40.206 of Sqlite.Interop.dll from http://system.data.sqlite.org/downloads/220.127.116.11/sqlite-netFx35-static-binary-Win32-2008-18.104.22.168.zip
, and placing Sqlite.Interop.dll in the bin/Debug/x86/ folder as a temporary workaround.
At this point, the example runs, but no differences are found. Placing a breakpoint on line 65 of BackupComparisonExample.cs, you can inspect session.TableDifferences and see it contains no items.