Solved

Management Studio - Move table from one database to another.

Posted on 2007-04-11
3
190 Views
Last Modified: 2010-03-19
This question is about SQL Server 2005 Management Studio.
Both databases are visible within Management Studio.  They are both in the same instance.  All permissions are properly granted.

Please outline the steps necessary (using Managment Studio) to move a table from one database to another.

 
0
Comment
Question by:Volibrawl
  • 2
3 Comments
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 18889049
Schema only, or schema and data?  If you want data, you are probably going to have to use SSIS which I am not very familiar with.

For just schema, right click the table, Script table as>>Create To>>(pick the appropriate option)

Then run that script against the other database to create it
0
 
LVL 9

Author Comment

by:Volibrawl
ID: 18898046
Schema and data.
0
 
LVL 21

Accepted Solution

by:
Kevin3NF earned 125 total points
ID: 18898403
SSIS or if the destination table does not exist:

Select *  --all columns
Into MyTestDB2.dbo.Test --destination database (usnig 3 part naming convention)
From MyTestDB.dbo.Test  --source database
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now