Merging data between databases

Question

Suppose I have two distinct databases with identical schemas but different data. I want to merge the data between the two databases by adding the data from one into the other. Foreign key relationships, etc. need to be maintained when the data is migrated.

Are there any tools (or databases that have built-in tools) to make this job fairly simple?

score 4 · Accepted Answer · answered Sep 09 '09 at 21:44

4

Red Gate SQL Data Compare

Best tool I have found for this type of thing, hands down.

answered Sep 09 '09 at 21:44

JohnFx

34,542
18
104
162

score 1 · Answer 2 · edited May 23 '17 at 12:00

1

This functionality is built into Windows Team System (the database edition or the suite). I have tried both this and an older version of Red Gate's SQL compare and both are awesome to work with. There are also some free tools (see this thread) but I do not have experience with any of them

edited May 23 '17 at 12:00

Community

1
1

answered Sep 09 '09 at 21:54

Jason Irwin

1,985
2
29
42

score 1 · Answer 3 · edited May 23 '17 at 12:33

1

2 options that I know of:
1. You can use SQL Server Data Tools. For instructions on how to compare data take a look here.
2. Another option which is xSQL Data Compare. For an explanation on how to use it, check out my answer here.

Disclosure: I'm affiliated to xSQL

edited May 23 '17 at 12:33

Community

1
1

answered Sep 20 '16 at 08:37

Endi Zhupani

736
2
7
22

score 0 · Answer 4 · answered Sep 09 '09 at 21:55

0

Visual Studio Team/Database versions have schema/data comparison tool.

answered Sep 09 '09 at 21:55

Codism

5,928
6
28
29

Merging data between databases

4 Answers4