Using Windows Synchronization Manager on x64 to Synchronize Replication (REVISED)
Windows Synchronization Manager on x64
SQL 2005 BOL topics describe how to launch the Windows Synchronization Manager to synchronize a subscriber.
How to: Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager)
On x64 system, the BOL steps will start the x64 Win Sync Manager not the 32bit version. The x64 bit will not show Replication subscriptions.
On Windows 2003 64 bit machine, the 32 bit Sync Manager can be launched using the below steps.
To execute 32bit Windows Sync Manager.
- Open a cmd prompt or Windows Explorer
- CD to Windows\Syswow64
- execute mobsync.exe
The Mobsyc.exe or Sync Manager is always 64bit on 64bit Edition of Windows 7, Windows 2008 & Windows Visa. This means the Sync Manager will not show SQL 2005 32bit Replication Subscribers even if mobsync.exe is executed from the windows\syswow64 folder. However, Sync Manager will list the Replication Subscription for SQL 2008 64 bit Express.
Application Developers will no longer be able to just use 32bit SQL Express for both 32bit and 64bit Windows users. Developers using Express edition should plan, test, and package SQL 2008 64bit Express for their customer’s running 64bit Windows and package SQL 2008 32bit Express for those running 32bit Windows.
As an alternative to mobsync.exe, Application Developers can write SQL RMO code to perform the synchronization from their client-side application. See Replication Management Objects Concepts or Programming Replication Management Objects RMO.
1. Copy mobsync.exe and mobsync.dll from Windows XP Service Pack 3 – 32 bit (from c:WindowsSystem32 flder) to some user folder on Windows 7 64-.bit
2. Set up Compatibility mode to Windows XP Servie Pack 3 and "Run as administrator"
3. Run the newly copied mobsync.exe and it will work as on Windows XP
Of course it is technical solution. Potential licensing issues should be verified with Microsoft.