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 |
|
u2envy1
Yak Posting Veteran
77 Posts |
 Posted - 2007-06-22 : 03:39:35
|
| Hi,I have two databases that I would like to merge.They have auto numbers in the tables as the primary key.Parent & child tables exists.Any software I can buy to accomplish this ? |
|
|
u2envy1
Yak Posting Veteran
77 Posts |
Posted - 2007-06-22 : 06:15:12
|
| Please peeps........Any1 help !! |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-22 : 06:43:03
|
| merge how?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
u2envy1
Yak Posting Veteran
77 Posts |
Posted - 2007-06-22 : 08:31:11
|
| Take all the tables data from one database.That contain the same table schema in another database& transfer the data. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-22 : 08:32:31
|
| you can use SSIS for that_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Merge two databases