Import data from one database to another? Databases are the same

I have two instances of same database and I want to have only one instance of database, so what I need is to import data from one databes to another. Ofc I can go table by table, but there is lots of tables. I was wondering is there sql statement that can mer开发者_如何学Cge two databases or is there option in Microsoft SQL server database studio to this thing?

There is nothing built in like that.

If you don't want to go the manual way (comparing and then importing/exporting), you can look at a propriety tool like RedGate Data Compare that can accomplish this.