MySQL as Target

General Parameters

  • database – The only appropriate value is target
  • dbtype – The appropriate value is mysql
  • generatesql This parameter is to identify if database objects are to be created immediately (0 - value, default), or the SQL script creating these objects should be generated (1 value).

Database Connectivity

  • server – Host name or IP address of the database server
  • port – Database port
  • dbname – Database name
  • user – Database User name
  • password – Database User password

To prepare database on the “Database Settings” form provide connectivity setting and click “Test connection”.

 Click “Prepare for Replication” to prepare the Target database:

 

 

Clicking on the “Show Prepare SQL” will generate script creating necessary replication objects.