joining 2 DB's? - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

joining 2 DB's?

Author

Topic

Kzimmerman
Starting Member

8 Posts

Posted - 2004-09-17 : 14:42:01

Got 2 dB's from different locations in the organization. my goal is to make them both into one file, without overwriting any information. the formats of the tables are the same.

Ken Zimmerman
MIS Dept
American Red Cross

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-09-17 : 14:57:21

this should help:

select *
from
(select *
from db1..tableName1
union all
select *
from db2..tableName2)

Go with the flow & have fun! Else fight the flow

Kzimmerman
Starting Member

8 Posts

Posted - 2004-09-17 : 17:49:19

quote:
Originally posted by spirit1

this should help:

select *
from
(select *
from db1..tableName1
union all
select *
from db2..tableName2)

Go with the flow & have fun! Else fight the flow

OK, got those, will keep that in mind definately. Is there perhaps a GUI tool of some type that can perform the same function?

Ken Zimmerman
MIS Dept
American Red Cross

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-09-17 : 17:58:48

gui? well i don't know of any. but do you really do stuff like that with gui?? i'd rather have complete control over the data i manipulate in that way.

Go with the flow & have fun! Else fight the flow

Kzimmerman
Starting Member

8 Posts

Posted - 2004-09-20 : 09:43:31

<--- not a DBA, so i'd like to have an 'easy way out' if i could find it [:-P]
but it'll be dealt with, so no biggie..

Ken Zimmerman
MIS Dept
American Red Cross

Kristen
Test

22859 Posts

Posted - 2004-09-20 : 09:46:23

Use DTS to "append" the data from the tables in one DB into the corresponding tables in the other?

Kristen

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-09-20 : 09:47:06

well i'm not a dba either

but it alwys works out that an "easy way out" usually means long hours and a bunch of grey hair in the end... but hey that may only be me...