You can start the process to migrate data from one table
to another from the main menu.
Before you begin
A connection must exist for the database that you want to
migrate data to.
Procedure
To migrate data, complete the following steps:
- Create a change management script. In the Administration
Explorer, right-click the Change Management
Scripts folder for the database that you want to migrate
changes to and click New Database Change. A new change management script is created, and the change
management script is displayed in the Change Management
Script Editor.
A data design project is automatically
created in the Data Project Explorer. The name
of the data design project is the name of the database connection.
If a data design project with the name of the database connection
exists, the name of the new data design project is the database connection
name with a numeric suffix. The data design project contains and manages
the resources that are necessary to implement the changes to the actual
database.
Tip: To reuse an existing change management
script, complete the following steps to reset the script:
- If the change management script is already open, click the tab
for the script to ensure that the script is highlighted. Otherwise,
in the Administration Explorer, expand the Change
Management Scripts folder. Double-click the change management
script that you want to open.
- From the main menu, click .
- From the main menu, click . The Migrate Data wizard starts.
- Complete the steps in the wizard. The wizard
guides you through specifying the following information:
- The source connection for the data
You must identify a connection
for the database that you want to migrate the data from. You can select
an existing connection or create a new one.
- The source and target table pairs from which to unload and reload
data
You must identify the pairs of tables from which to save data
and into which to load the saved data. You can select the source and
target schema to map multiple tables simultaneously, or use the Add
New Entry icon to add tables one at a time.
When you have finished the steps in the wizard,
you can work with the changes in the Change Management Script
Editor.
- In the Change Management Script Editor,
click Preview Commands to generate and display
the commands for migrating the data in the Commands section.
Review the commands.
- Optional: To change the location for the unload
data file, the methods to unload or reload the data, or how unloaded
columns are mapped to reloaded columns, click Data Options to
start the Customize Data Preservation wizard.
Complete the steps in the Customize Data Preservation wizard.
Tip: When you migrate data, new rows are added
to the target table. The target table might contain columns that the
source table does not contain. If the target table contains columns
that are defined as NOT NULL and that do not have a default value,
you can customize the SELECT clause in the unload command on the Customize
Unload Commands page of the wizard.
- Click Run to start the Deploy
Change Commands wizard.
- Review the change commands, and click Finish to
migrate the data.