undefined

How can we help you today?

Exporting Select Tables from a SQL Database

Issue
How to export only select tables from a SQL database.

Product
Struxureware Power Monitoring
Power Monitoring Expert
ION Enterprise
ION EEM

Environment
Microsoft SQL Server

Cause
When troubleshooting database issues, examining specific tables, the data they contain, and having them available in a
test system can be very helpful in leading to the resolution or to identify the cause of problems. Often times though, a backup of the
entire database is very large making it difficult and time consuming to transfer from system to system.

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

Following the steps below will create a new database with only the subset of the selected tables which you will be able to easily back up and transfer to other systems or database instances.

1) Connect to the SQL instance using SQL Management Studio which has the database containing the tables to be exported.
Select Desired Database
2) Select database > Tasks > Export Data
Navigate Menu down to Export Data
3) This will launch 'SQL Server Import and Export Wizard'
Wizard Launches
4) Select the server name and database name from which the tables will be exported.
Select Server and Database
5) Enter the destination server information. The server name could be the same or it can be a different instance.
Enter Destination Database
6) Select the New database button
Select New Database
7) The Wizard will now prompt with a screen like below where a database name can be specified.
Enter New Database Properties
8) Configure or adjust the remaining database parameters as necessary and select the Ok button.
Configure all properties as desired
9) Click on Next and then select 1^st option "Copy data from one or more tables or views"
Select Copy Option
10) Select the tables to be exported.
Select table to copy
11) Select the Run Immediately checkbox.
Select Run Immediately
12) Examine and verify the choices shown in the Summary screen, select Finish to proceed.
Verify Sucessful Completion
13) A progress window will appear followed indicating a status of all operations being performed by the Wizard. All steps will should show as 'Success' upon completion.
Monitor Status
14) When complete, the new database containing the exported tables will be available. This database can now be backed up and transported to another system/instance as required.
Completed New Database now Available