Skip to content

Latest commit

 

History

History
50 lines (32 loc) · 1.86 KB

data-migration-settings-db2tosql.md

File metadata and controls

50 lines (32 loc) · 1.86 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.collection
Data Migration Settings (Db2ToSQL)
Data Migration Settings allow you to write custom queries for data migration, in SSMA for Db2.
cpichuka
cpichuka
randolphwest
09/24/2024
sql
ssma
conceptual
sql-migration-content

Data Migration Settings (Db2ToSQL)

Use the Data Migration Settings tab to write custom queries for data migration.

Remarks

This tab is available when Extended data migration options is set to Show and is hidden when the setting is set to Hide in Project Settings. For more information about Project Migration Settings, see Project Settings (Migration) .

Parsing of custom SQL statements are implemented in Data migration settings tab of the Table Node.

The following checkboxes are available in the Data Migration Settings tab:

  1. Truncate SQL Server table:

    This option allows the user to have a clear view of the migrated data at the target database.

    • By default, this textbox is checked.

    • If this textbox is unchecked, then the data that is migrated will be added on to the existing data at the target database.

  2. Use custom select:

    This option allows the user to modify the select statement present (select statement allows the users to select the data to be displayed at the target database).

    1. By default, this textbox is unchecked.

    2. If this textbox is checked, then it allows the users to modify the select statement present.

There are two buttons present:

  • Select Apply to apply the settings that have been changed.

  • Select Cancel to restore the settings present before the changes were being made.

Related content