Before You Begin
(1) The target self-built Dameng database version is DM7 or DM8.
Permission Requirements of Target Server
Migration Mode | Required Permissions |
Full | COMMENT ANY TABLE, CREATE ANY TABLE, ALTER ANY TABLE, CREATE ANY SEQUENCE, CREATE ANY INDEX, SELECT ANY TABLE, INSERT ANY TABLE, DROP ANY TABLE, DROP ANY VIEW, DROP ANY SEQUENCE, DROP ANY INDEX, DELETE ANY TABLE |
Incremental | DELETE ANY TABLE, SELECT ANY TABLE, INSERT ANY TABLE |
Auditing Repair | SELECT ANY DICTIONARY, SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE |
Configuration on Target Server
Data source type: Set this parameter to DMENG. The source database can be migrated to the DMENG databases within the version range.
Server IP: Specifies the IP address of the target database.
Port number: Specifies the port of the target database.
User name: Specifies a user name used to connect to the target database.
Password: Specifies the password of the user used to connect to the target database.
Schema: Specifies the schema name used by the target server to receive data from the source server.