Been following a video from Jim Wilson on merge replication between sql server 2005 and compact 3.5. The problem I have is that in the video, the subscriber types say SQL Server Compact, but on my 2005 server it says SQL Server Mobile. I have installed all the parts of Compact 3.5, so how do I get 2005 to use Compact and not Mobile?
Please download SQL Server 2008 CTP 6 from http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx. SQL Server 2008 CTP provides the publication and subscription support and the ability to run SQL queries for SQL Server Compact 3.5.
SQL Server 2005 can be used to create publicatons for SQL Server Compact 3.5 however it does not have the support for creating subscriptions and for running SQL queries for SQL Server Compact 3.5. The file format has changed in SQL Server Compact 3.5 and this is the reason of the incompatibility. SQL Server 2005 SSMS can be used with SQL Server 2005 Compact Edition (SQL Server Compact 3.1)
One of the main work items for us for the next release is to make SQL Server Management Studio work with different versions of SQL Server Compact. This will ensure that the problems about the version support for SQL Compact in SSMS do not occur
As Jacob said it is just a mater of a changed naming convention however we are currently working on a smart client and originally looked at merge replication until we became aware of Microsoft's Synchronization Services for ADO.NET. Merge replication is really for keeping servers in sync but it has been hijacked for use with offline applications. RDA (Remote Data Access) tried to address this but is lacking some what in functionality. The new Synchronization Services library has a whole suit of tools for synchronization which are fully extensible.
This should get you started with synchronization services. even if you are not interested it does a good comparison on the available features of each of the technologies I mentioned above.
If what you are doing is simple you may be interested in merge replication, everything you need to get you started can be found here
Should you still wish to continue with merge replication you can find a step by step guide here:
Feel free to ask any questions and I will pass on what I know.
Thanks for the replies.
Ambrish, so how is Jim Wilson doing it in his video then? He is using SQL 2005 and compact.
Jacob, thanks for that, I will install sp2 and let you know how it goes.
Bronumski, thanks for the info, sounds interesting!
Again, thanks for the help,
Jim's video at http://msdn2.microsoft.com/en-us/netframework/bb500978.aspx and at http://msdn2.microsoft.com/en-us/netframework/bb510380.aspx are very good and highly informative. Jim has used SQL Server 2005 SSMS, Visual Studio and SQL Server Compact 3.5 to set up the merge replication by doing the following:
1. SQL Server 2005 SSMS can be used to setup a publication for the SQL Server 2005 Compact Edition subscriber. SQL Server Compact 3.5 and SQL Server 2005 Compact Edition have the same publication characteristics. A publication setup for SQL Server 2005 Compact Edition can be used by a SQL Server Compact 3.5 subscriber
2. The subscription has been programmatically setup using Visual Studio. Information about this is available at http://msdn2.microsoft.com/en-us/library/ms172077(SQL.100).aspx
SQL Server 2008 SSMS inetgartes the SQL Compact 3.5 subscription wizard which can be used to subscribing to a SQL Server publication. You can use either the approach shown in Jim's video or use SQL Server 2008 CTP 6 SSMS and Visual Studio 2008 to setup the merge replication. More tutorials are at http://msdn2.microsoft.com/en-us/sqlserver/bb219480.aspx