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
RDA and replication
Hot Topic
- Please help me with my Top N query
- active/active clustering
- Using dataset as datasource
- Making SSAS Developer Edition act like standard edition
- Chart not reflecting new Dataset Changes
- Passing Collections to Custom Code
- system error 126
- Where can I find SQLCMD?
- Executing SSIS package from stored procedure
- Question about the way that some element are displayed in the viewer
SQL Server
- HELP - Problem with Replication
- Can't connect to SQL Server 2005
- Maintenance Cleanup task not functioning properly???
- Authentication Issues
- How to design this cube?
- Value setting is RS on bit fields issue
- How to connect database under Windows Authentication?
- Getting sample databases in Management Studio
- Changing login permissions
- MSDE & SQL Server 2005 Mobile Server Tools problem
RDA and replication
SamusAran03
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
Bob Davidson
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.