Issue
How to export only select tables from a SQL database.
Product
Struxureware Power Monitoring
Power Monitoring Expert
ION Enterprise
ION EEM
Environment
SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014
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.
2) Select database > Tasks > Export Data
3) This will launch 'SQL Server Import and Export Wizard'
4) Select the server name and database name from which the tables will be exported.
5) Enter the destination server information. The server name could be the same or it can be a different instance.
6) Select the New database button
7) The Wizard will now prompt with a screen like below where a database name can be specified.
8) Configure or adjust the remaining database parameters as necessary and select the Ok button.
9) Click on Next and then select 1st option "Copy data from one or more tables or views"
10) Select the tables to be exported.
11) Select the Run Immediately checkbox.
12) Examine and verify the choices shown in the Summary screen, select Finish to proceed.
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.
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.
Released for:Schneider Electric Canada
