Merge/Join 2 DB into 1 - 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 2005 Forums

SQL Server Administration (2005)

Merge/Join 2 DB into 1

Author

Topic

novanakal
Starting Member

1 Post

Posted - 2011-04-22 : 04:59:54

i Have a Problem With this

i want to merge into 1 DB
ex :
USERNAMEDB with 24 Table
and
USERDB With 6 Table

in case :
USERNAMEDB not have table like USERDB
and USERDB not have too like USERNAMEDB
how to join/merge 6 Table from USERDB into USERNAMEDB
include Views, Synonyms, Programmability, Service Broker, Storeage and Security.

thx for your attention, sorry for my bad english

manju3606
Yak Posting Veteran

78 Posts

Posted - 2011-04-27 : 03:07:25

you can merge by using DTS packages

Manju

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources