Solved

Management Studio - Move table from one database to another.

Posted on 2007-04-11
3
192 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

770 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