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 Andrzejek 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
804
Sana Shazadi
S
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
467
pjw001
pjw001
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
453
Volvere
V
coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
435
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
292
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top