combining database ?

[nowayout]

Hi all,

How can i combine the database? can i use DTS to import / export the data in to one database?

or i have to write script for that?

help please and any goor resource book for that

thanks

 

[Kapgemini]

Hi ..
If the table structure is same yo u can also use insert into select * from format.

The usage is that you can create the dynamic query and then run them at one go so that it would be easier

select "insert into " + name form sysobjects where type ='U'

tyeps

U can as well use DTS