How to merge tables from 2 databases in SQL Server 2008 -

i'm using sql server 2008 - standard edition. sorry if rather basic question, know little sql

i have 2 databases i've created using visual studio benefit being merged. merged mean copying tables 2nd database first , deleting 2nd database.

is there simple way of doing through sql management studio?

you can use openrowset read data 1 database , merge another.

for example:

use dbtomergeinto;  insert tabletomergeinto select * openrowset     ('sqloledb',       'trusted_connection=yes;server=192.168.1.1\servertomergefrom',      'dbtomergefrom.dbo.tabletomergefrom')