Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2008 - Change Data Capture - Merge question

Status
Not open for further replies.
Ovatvvon

Ovatvvon

Programmer
Feb 1, 2001
1,514
US

Hi all,

We're trying to find a good solution to do incremental updates across databases. I was looking at the Change Data Capture feature in 2008, as well as Merge command for it.

Does anyone know if this feature requires the two tables (source and destination) to be in the same database? Or can it propagate across databases, or across servers?


-Ovatvvon :-Q
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
SSMS question 1
Replies
4
Views
673
Sana Shazadi
S
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
330
pjw001
pjw001
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
356
Volvere
V
coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
298
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
229
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top