Monday, March 12, 2012

Merge Replication Issues between SQL Server 2005 (x64) and SQL Server Compact Edition

Hi ppl,

I have installed SQL Server 2005 x64 Enterprise edition with Service Pack 2 on a Windows Server 2003 x64 Standard Edition with Service Pack 2.

Now I have to configure Merge Replication that will work with SQL Server Compact Edition database on Windows Mobile devices.

Distributor and the Publisher are the same server.

IIS 6.0 is installed on the windows server. I have installed the SQL Server Compact Edition Server tools on the server. However the compact edition server tools are only available for 32bit servers and I have also found out from the article http://support.microsoft.com/default.aspx/kb/912430 that you cannot replicate data from SQL Server 2005 to SQL Server Compact Edition by using the 64-bit version of IIS.
So if this is true does that mean I can not use merge replication on 64 bit server? Does that mean I have to get another 32 bit server with 32 bit IIS on it to make this work or is there another work around. Am i missing something here?

Regards
NabeelI think this might solves the issue http://www.pluralsight.com/blogs/jimw/archive/2007/07/06/47932.aspx

No comments:

Post a Comment