Use of Dameng DTS tool

Data migration
Data migration Dameng provides data migration tools , In the installation directory tool In the catalog dts

Open software
Right click in the migration management window , New project ( If there is no migration management window , You can click View -> window -> Migration management opens )
Enter project name 、 describe , determine , The project name here is convenient for us to distinguish

Click to expand the new project , Right click migration -> New migration

Enter the migration name 、 describe , determine , Here is also the migration name for us to distinguish
Click OK to enter the home page , Go straight to the next step
Then select the data to be migrated , It also supports exporting from Dameng to other databases , I am here MySQL Migration to dream , Select next
Conduct MySQL Configuration of data source , Select the database to migrate , Next step after configuration , If MySQL The version is not 5.x It is recommended to specify the drive manually

Configure the data source of Dameng , next step

Check the box , Then you can choose the destination mode , Is the name of the library to be imported , The creation mode can be checked , If not, it will be newly built , next step

Select the table to migrate , You can click to select all , next step

Here is the implementation of the task , There is no problem. Click Finish to migrate data , If there is a task error , It can be handled manually , For example, table creation failed , You can copy the table creation statement and manually execute it in Dameng database after modification , Then try to migrate again , Import data .

https://eco.dameng.com