469,613 Members | 1,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,613 developers. It's quick & easy.

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

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.
Jul 30 '07 #1
1 7185
ck9663
2,878 Expert 2GB
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.newtable from olddb.dbo.oldtable
Jul 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by lgbjr | last post: by
5 posts views Thread by Clodoaldo Pinto Neto | last post: by
2 posts views Thread by Geoffrey | last post: by
6 posts views Thread by sql_server_user | last post: by
4 posts views Thread by JIM.H. | last post: by
12 posts views Thread by alanchinese | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.