Migrating data by using menu options

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:

  1. 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:
    1. 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.
    2. From the main menu, click Change Management > Reset.
  2. From the main menu, click Change Management > Migrate Data. The Migrate Data wizard starts.
  3. Complete the steps in the wizard. The wizard guides you through specifying the following information:
    1. 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.

    2. 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.
  4. 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.
  5. 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.
  6. Click Run to start the Deploy Change Commands wizard.
  7. Review the change commands, and click Finish to migrate the data.

Feedback