RDA and replication

hi there,

i was about to create an device application that will retrieve data from my desktop pc that install with SQL server 2005. using RDA or replication is more suitable?

what is the difference between them?

The following links describe RDA and Replication and the differences between them.

RDA: http://msdn2.microsoft.com/en-us/library/ms172029(en-US,SQL.90).aspx

Replication:http://msdn2.microsoft.com/en-us/library/ms172407(en-US,SQL.90).aspx

RDA vs Replication: http://msdn2.microsoft.com/en-us/library/ms172916(en-US,SQL.90).aspx

Deciding between RDA and Replication depends on the nature of your device application.

If your requirement is simply to pull data from your desktop SQL Server to the SQLMobile database on your device, RDA would be a simpler option.

|||

And the comparison of both RDA & Merge Replication is @. http://msdn2.microsoft.com/en-us/library/ms172916(en-US,SQL.90).aspx

This details out and should definitely help you in finding out the right solution for your scenario.

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Mobile, Microsoft Corporation