Issue
Often when troubleshooting and\or correcting data issues, it is desirable to work on a temporary or subset of the production data
to in order to test a solution or to focus on a small portion of some particular data item(s).

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, SQL Server 2016, SQL Server 2017, SQL Server 2019, SQL Server 2022

Cause
Troubleshooting or correcting data issues.

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.*

An easy way to create a copy of a table is to use a SQL command.

Use SELECT INTO to extract all or a subset of the rows or from an existing table into the new table.
The new table must not exist already.

The following example will copy the Source table under the IonNetwork schema to a new table called MySource under the Test schema:
SELECT * INTO Test.MySource FROM IonNetwork.Source

You can also create the new table from a specific subset of rows in the original table.
In this case, you would append a Where clause to specify the criteria for only those rows you are interested in.
SELECT * INTO Test.MySource FROM IonNetwork.Source
Where Name like '%MySources%'

You can then set whether you want to copy just the schema of the table or the data along with the schema.

發佈於: 施耐德電機Taiwan