Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jrockfl
Posting Yak Master
223 Posts |
 Posted - 2004-12-10 : 17:03:04
|
| I set up a transactional replication between 2 datbases. How does it update the subscriber table? Does it drop the table like a DTS or does it just update records that are changed?Where can I find some more resources for this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-10 : 17:19:51
|
| SQL Server Books Online has loads of information about replication. To answer your question though, it depends on how you set it up. For the initial snapshot, the default is to drop them and recreate. After that, it sends the transactions over as INSERT/UPDATE/DELETE or via stored procedures again depending on how you set it up.Tara |
 |
|
|
jrockfl
Posting Yak Master
223 Posts |
Posted - 2004-12-11 : 13:39:12
|
| How do I access this books online? Do I have to download anything? I did a search and something about downloading it.Is replication faster and a better way of transfering data then DTS?Let's say I have a table with 10000 records and 100 records are modified, does a transactional replication just update those 100 records without dropping and recreating the table?If that's the case, I think that would be a lot faster then a DTS that drops the table, recreates it and then copies the 10000 records. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-11 : 14:05:40
|
| Books Online is installed with SQL Server, there's a link to it in the same Start Menu folder as Enterprise Manager, Query Analyzer, etc.Replication would be more efficient than DTS would, but it comes with some limitations. Table structures cannot readily be altered if the tables are being replicated, and certain types of replication may affect their design; DTS would not incur either of these. Books Online covers these issues very thoroughly. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-12-13 : 11:53:02
|
quote:
Originally posted by jrockfl
Is replication faster and a better way of transfering data then DTS?
Replication and DTS have their own uses. In my production DB DTS is much faster than replication. If you are ONLY INSERTING data and NOT updating it then go for DTS.quote:
Originally posted by jrockfl
Let's say I have a table with 10000 records and 100 records are modified, does a transactional replication just update those 100 records without dropping and recreating the table?
Yes. Replication will not drop the table..I would suggest merge replication ..instead of transactional. What is your requirement?quote:
Originally posted by jrockfl
If that's the case, I think that would be a lot faster then a DTS that drops the table, recreates it and then copies the 10000 records.
I don't think DTS will drop the table. Unless you select that option.------------------------I think, therefore I am |
|
|
|
|
|
|
|
|
Replication