Hi, we have the exact code as your example working fine against SQL Server 2008 R2.
We have now upgraded to SQL Server 2012 but your example does not work.
When building in x64, the exception is:
Could not load file or assembly 'Microsoft.SqlServer.Replication, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.
When building in x86, the exception is:
"Class not registered"
Can you provide please the same example but with the updated DLLs so it works with SQL 2012?
I have already tried with Replication and Rmo DLLs from C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies with the same results
Thanks in advance!
I am using the exact code to Synchronize a Merge Pull Subscription.
Everything works fine on my local system. But when I deployed my application to a machine where SQL Server Express 2012 is already installed, I do not get any error but it fails at following line.
subscription = new MergeSubscription();
Please note I have used following dll versions:
Microsoft.SqlServer.Replication - 10.50.2500.0
Microsoft.SqlServer.Rmo - 10.50.1600.1
Please help me to resolve this issue. Thanks in advance
I have a similar situation as Geoff. We have a .NET application that works for SQL 2008R2 OR SQL 2005 (by switching the RMO, Replication, ... DLL references from version 10 to 9 and vice versa). Is there a solution to have one set of DLLs included in the .NET application to support different versions of SQL Server?
I might be out. Is there any RMO programming examples for SQL Server 2012?
It seems to me also that MS has not been published any updates for Sync Framework since 2011. By any chance if you know can SQL Data Sync replace it?