How to copy data from a table in one database to another database using sqlserver2005

yasinirshad

New Member

Join Date: Jul 2007

Posts: 3
#1

How to copy data from a table in one database to another database using sqlserver2005

Jul 30 '07, 06:03 AM

HI,
Can anyone tel me How to copy data from a table in one database to a table in another database using sqlserver2005. Thanks in advance.
Tags: None
ck9663

Recognized Expert Specialist

Join Date: Jun 2007

Posts: 2878
#2

Jul 30 '07, 11:47 PM

Originally posted by yasinirshad

HI,
Can anyone tel me How to copy data from a table in one database to a table in another database using sqlserver2005. Thanks in advance.

use your enterprise manager...

or do a select * into newdb.dbo.newta ble from olddb.dbo.oldta ble
Comment

Comment