Re: How to synchronize SQL CE 2005 with SQL Express or Standard 20

And "SQL Server 2005 Compact". (does not support Publication) ;)
I told you that it was a mistake giving it the same name as the other
editions.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote in message
news:6A136D62-BD38-4FBB-A285-EA1FADE344BA@xxxxxxxxxxxxxxxx
Any version of SQL Server other than Express supports serving as a merge
replication publisher.

--
Ginny


"TheSQLFool" <TheSQLFool@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:62155723-9802-47CE-B493-A9389A9C1544@xxxxxxxxxxxxxxxx
Hi Ginny,

I am currently reading this article and using the Trial edition for SQL
server 2005 to try out merge replication.

http://msdn2.microsoft.com/en-US/library/aa454892.aspx

Only problem is, I am unaware whether there are features inside the Trial
edition that are not available inside the Standard edition, for eg, web
synchronization. We intend to buy the Standard edition for our own
purposes
but before we buy, we need to check whether we can do merge replication
properly using Standard edition as publisher.

Please advise.

Thank you.

"Ginny Caughey [MVP]" wrote:

Eventually, Sync Services is intended to replace RDA, but since Sync
Services is only in beta at the moment and not yet feature complete,
it's
premature to consider it a replacement yet. When it is finished, it will
indeed be better than RDA in my opinion because it will be more
powerful,
more open, but also because it will support a variety of transports also
be
more flexible. For example, both RDA and merge replication rely on IIS
to
provide the "plumbing" and this requirement will not be necessary with
Sync
Services.

RDA works with all versions of SQL Server. You could use it or merge
replication to sync multiple mobile devices since both merge and RDA use
IIS
for the connection to the SQL Server. Whether you choose merge or RDA
depends on how you'll be moving data. Merge is more powerful and more
flexible and allows you to pull down only the changes, but it is also
trickier to set up. RDA is easier to use but is also more limited - for
example when you Pull data, you create an entire new table rather than
just
inserting changes into an existing one and you have to handle confict
resolution yourself in code. You can read about Merge Replication and
RDA in
SQLce Books Online.

--
Ginny





.

Relevant Pages

  • Re: Merge replication or manual one?
    ... administration you can tolerate. ... If you're on a high speed network, Merge, RDA, or a web-services ... based approach to replication are all great options. ... >I have a one SQL Server 2000 and plenty of SQL Servers CE on PocketPC's. ...
    (microsoft.public.sqlserver.ce)
  • Re: Problem in the rda.Push operation
    ... I would not suggest using IDENTITY columns with RDA. ... The error message you are receiving sounds more like a Merge replication ... For some reason, SQL Server ...
    (microsoft.public.sqlserver.ce)
  • Re: How to synchronize SQL CE 2005 with SQL Express or Standard 20
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... server 2005 to try out merge replication. ... We intend to buy the Standard edition for our own purposes ... both RDA and merge replication rely on IIS to ...
    (microsoft.public.sqlserver.ce)
  • Re: How to synchronize SQL CE 2005 with SQL Express or Standard 20
    ... One other solution would be to write your own home grown replication web ... both RDA and merge replication rely on IIS to ... RDA works with all versions of SQL Server. ... replication to sync multiple mobile devices since both merge and RDA use IIS ...
    (microsoft.public.sqlserver.ce)
  • Re: Publish scenario - how can this work?
    ... Otherwise I would replicate from the Standard Edition publisher to the ... Looking for a SQL Server replication book? ... Subscriber and not a Publisher. ...
    (microsoft.public.sqlserver.replication)
Loading