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 |
ykram511
Starting Member
4 Posts |
Posted - 2008-07-02 : 05:54:47
|
Hey Guys,I have a table on one instance (Instance A) that I've replicated to another instance (Instance B). The table on Instance B needs to be updated regularly (daily) to ensure that any changes (additional records, deletions, updates) on the table on Instance A is replicated on Instance B. Currently, I'm using SSIS Transfer SQL Server Objects task to accomplish this. However, this method always truncates the table in Instance B and copies ALL records from Instance A each time. I was wondering if there is another way (or task) I can use that will do it in such a way that only changes to the table in Instance A are replicated to Instance B. Is this possible? |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-07-02 : 06:07:49
|
Yes, replication, you will then not need to update on a daily basis (unless you just want to snapshot it) as the tables could keep in sync data-wise.Look up transactional replication or snapshots. |
 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-02 : 10:25:38
|
you should have primary-key for Transactional Replication. |
 |
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-03 : 10:37:14
|
did you check the appropriate setting in the task, as existing Data to append etc. Or you can use a Linked server and do an INSERT or SELECT INTO statements.ManinderDatabase Painter.. Leaving strokes, that amaze! and inreturn, put value to your Work. I am a Database [Architect / Administrator] |
 |
|
|
|
|