How to make a single database from two databases ....

Hi ...

I have two separete databases, what Ineed is that I want to make a single database of the two. Although all the table definitions of both the database are same.

I will be glad to know "how to make a single database from two" and i will be happy to see the query to insert the values from one database to another one.

Abdul Ghaffar

That depends on the schema definition, do you have constraints enabled which should be treated the right sequence ? Do you want to import the data automatically ? YOu might have an eye on the DTS packages as they are able to do this and additionally enable the identity insert for you if specified and needed (and if the identities do not interfer with the other database). For my opinion merging two database is not a straight forward automatical process. There is always much manual work needed to do this with a 100% result.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de