• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

how to move table between databases

hello,

I have database1 , which contains two table ... table1 and table2..
I created database2 on same server and I want to move table2 in database2. how can I do that? Any script or DTS is the only way?
Please guide me.

0
pinaldave
Asked:
pinaldave
3 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you can copy a table by getting the script generated for the structure, with which you create the table on the second database.
to copy the data:

INSERT INTO database2.dbo.table2
SELECT * FROM database1.dbo.table2

if you want to do a move, drop the table once you done the copy

in DTS, you can use the transfer objects scripts
0
 
MageDribbleCommented:
would this statement work?  I've never tried this solution and don't have access to a SQL server right now.  My guess is it would work but the columns may not be the same datatype between the two tables.

SELECT * INTO database2.dbo.table2
FROM database1.dbo.table1
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes it would work, the data types will be copied
0
 
imran_fastCommented:
hi  pinaldave,

you can use this

Select * into database2.do.Table2 from Database1.dbo.table2
0
 
pinaldaveAuthor Commented:
Thank you all. I end up using DTS :)
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now