Solved

Management Studio - Move table from one database to another.

Posted on 2007-04-11
3
194 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How can I get this column in my query? 2 62
Query to return total 6 26
Gettg error - Please help Msg 252, Level 16, State 1, Line 1 3 36
SSMS Imprt data from Excel 7 37
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
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 …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

732 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