Get the App
SLTechnology News&Howtos  ›  Database  › 

User manual of Dameng database migration tool DTS

Shulou Source: shulou.com Published: 2022-06-01 04:43:49 10月28日 Update

"Dameng database migration tool DTS user manual"

1. Open the DM data migration tool DTS

two。 Click New Project

3. Enter project name

Enter the project name, which can be customized. Click OK after input.

4. New migration, create migration task

5. Enter the migration name

Enter the migration name, which can be customized. Click OK after entering.

6. After the migration is created, the migration wizard pops up, as shown in the following figure:

7. Click next and select the migration type (source side = > destination side)

8. Enter source-side connection information

Input source connection information including: host ip, database listening port, database instance name, source database login account, source database login password

After the above information is entered correctly, click next.

9. Enter the destination connection information

Enter the connection information of the target side, including: host ip, database listening port, target database login account, target database login password

After the above information is entered correctly, click next

10. Selection of migration mode / object

You can choose mode 1 (sql result set) and mode 2 (direct migration of data object users); you can filter by entering the user name of the source side that needs to be migrated in the "find object name", and you can manually modify the "destination mode" to set the target side to import users.

Click next to continue.

11. Select the migrated table

Click next to continue

twelve。 Confirm the migration information and start the migration

After confirmation, click finish to start the migration action.

13. Check the migration log and there is no error message, which proves that the migration is complete.

Tags: Input data database information target project login selection name object method user tool host password port account monitor manual task Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Information OPPO Reno Xiaomi Microsoft Apple