What is the main difference between RDA and Replication?
Where are the advantages and the disadvantages of this two procedures?
Thanks
Robert Stephan
by Robert Stepha » Wed, 28 Feb 2001 17:45:14
Thanks
Robert Stephan
by Syed N. Yousu » Fri, 09 Mar 2001 02:57:45
Thank you very much for your question on SQL Server CE.
Please take a look at detailed threads on the same topic posted earlier on
this newsgroup.
Thank you!
Syed Yousuf MCSE, MCDBA
Hello all,
I've worked through several of the samples provided with SSCE. I like both
the RDA and the REPL samples, but am still a little confused on when it's
best to use one over the other. My impression is that RDA is simpler and
easier, and requires very little if any modifications to the SQL 2K server.
Once the IIS virtual dir is set up, your off and running. The advantage
being if you have several SQL Servers, you can sync your data with them
easily. The one down side I saw is that if you want to refresh the local
database (RDA file) you have to delete and recreate it, and reinforce all
PK-FK links, Default values, etc...
The Repl seemed more powerful, and flexible, but had definite setup
requirements, as well as the fact (if I interpreted it correctly) that you
could only sync (replicate) with that specific SQL Server.
Does anyone have a definitive chart/list the compares and contrasts RDA and
REPL? How about "real world" scenarios when one method would be better than
the other. How about ADOCE vs OLEDB for CE
I'm still learning this stuff, so I'm sure I missed something.
2. Visual Basic API for Essbase
3. Problem when using RDA and REPLICATION
4. MS-SQLSVR6.5 sp4 won't update sqlsrvr client utilities.
5. RDA Versus Replication - Which To Choose?
6. US-TX-SENIOR ORACLE ARCHITECT/DESIGNER
8. SQL7.0 Installation Problems
9. RDA/Replication and the internet
10. RDA or replication via http for SQL (not CE)
11. RDA and Replication difference, Pro and cons
13. Mixing RDA and Replication