• Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

Data migration

You can migrate data from source tables and views to target tables. The data migration is processed by the bulk insert command that ensures the high speed of data transfer. See how this operation is performed.

  1. Create a new project or open an existing one.

  2. Select the operation scope by choosing the desired nodes on metadata trees.

  3. Click Migrate to Right or Migrate to Left button in the Data Operations panel depending on location of target and source tables. You will get to the matching page.

    Here you can adjust objects matching if needed.

  4. Click the Maximize button to see the operation details in the fullscreen mode.

  5. Click the Options button at the bottom right-hand corner of the central window. You will get to the Data migrate options page.

  6. Click the Run button at the bottom right-hand corner of the central window to get the result.

    New data will be added to the target tables. At the end of the process, you’ll see the amount of data rows actually migrated from source tables.

  7. Click the Export button at the bottom right-hand corner of the central window to save the migration statistics in the log file.

  8. Click the Close button at the top right-hand corner of the central window to close the Data migration window.