Moving tables across databases

Question

Moving tables across databases

gresford

Say Hey Kid

Points: 703
More actions
September 14, 2007 at 1:16 pm

#178466

Is it possible for me to move a table from one database to another?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mike Howell Mr or Mrs. 500 Points: 521 More actions · Answer 1

I don't know how it would be possible to move teh table with all data except for creating the table in the new database and then inserting the data into that database.

SELECT *

INTO NewDatabase.dbo.TableName

FROM dbo.TableName

You would want to make sure you have the scripts to create all of the objects like constraints, indexes, defaults, etc.

teligaurav SSC Journeyman Points: 78 More actions · Answer 2

hi this is Gaurav Teli

you can do it by GUI UTILITY , right click on Sql Server Instance that is Child of Databases Node in ObjectExplorer -> Task -> Import Data , Export Data , Select your Dest. and then Source Server to copy all or selected objects

Regards

Gaurav Teli

Software Engg.

Algorithm Softwares

Adonis Andrews Grasshopper Points: 17 More actions · Answer 3

1. CREATE THE NEW DATABASE

Open the SQL Server Management console. Right click the "Databases" node and choose "New Database..." In the New Database window input the name of the database that you want to create and click OK.

2. EXPORT THE TABLES

Use the DTS wizard to export the tables from the original to the new database. DO NOT export the views because they will export as tables. The tables will export to the new database EXACTLY as it is in the original. Data and primary keys will be preserved. The DTS wizard may be accessed using the following path: C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

2a. IF DTS WIZARD IS NOT INSTALLED

- It is included in the SQL Server Express Edition Toolkit. The download site is: http://go.microsoft.com/fwlink/?LinkId=65111

- The DTS Wizard is included in the option “Business Intelligence Development Studio” so be sure to select that for install

- If you have installed another version of SSE, the installer might report that there is nothing to install. Override this by checking the checkbox that displays the version number (in the installer wizard)