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 |
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
 Posted - 2010-08-19 : 06:33:17
|
| Hello. I want to know if there is a way to replicate only changed data if I am using Snapshot replication in sql server. I cannot use transactional replication because there are certain tables that do not have a primary key, this prhibits me from using transactional replication.So, I need to know either of the two:1. A way to take something like incremental snapshot and apply it to the subscriber (cannot take full snapshot everytime as I have to take snapshot every 20-30 minutes and this will use huge bandwidth of the link).2. A way to include all the tables (even if they don't have primary key) and related data when using transactional replication.Note: The changes have to propagate from primary to secondary database and not vice versa. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-08-19 : 06:46:33
|
| Why not create primary keys for the tables? This should only be a problem if your code is using SELECT * or INSERT INTO without field lists, which is bad practice anyway..The upside is that even with a surrogate key (identity or user defined), you will speed up your queries and inserts.. |
 |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-08-19 : 09:04:48
|
| The database comes with the application, cannot add primary key. I want to replicate the database as part of DR plan. The snapshot replication could work but I cannot transfer GBs of data every 30 minutes over the link.What is a surrogate key? Does it require any changes on the database side? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-08-23 : 06:28:36
|
| Thanks!! |
|
|
|
|
|
|
SQL Server replication