Before You Begin
(1) The target self-built PostgreSQL database version is 2008 R2, 2012, 2014, 2016, 2017, or 2019, and the version is later than or the same as that of the source database.
Permission Requirements of Target Server
Migration Mode | Required Permissions |
Full | SELECT, DELETE, INSERT, CREATE TABLE, ALTER, REFERENCES |
Incremental | SELECT, INSERT, DELETE |
Auditing Repair | SELECT, INSERT, DELETE |
Configuration on Target Server
Data source type: Set this parameter to SQL Server. The source database can be migrated to the SQL Server 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.
Database: Specifies the name of the database used by the target server to receive data from the source server.
Schema: Specifies the schema name used by the target server to receive data from the source server.