Improving Performance Using Refresh with SQL Server

  • Updated on Mar 24, 2024
  • Published on Mar 24, 2024
  • 1 minute(s) read
Prev Next

If you are replicating to Microsoft SQL Server or MySQL using Refresh mode, you can improve performance by using the bulk insert option during replication. This option is selected by default in the Preferences tab of the Replication Properties dialog.

  1. In the Target Connection wizard, when creating a target connection, select the Microsoft SQL Server .NET Data Provider or the MySQL .NET Data Provider.

  2. In the Replication wizard, when configuring the replication, choose Refresh as the Replication mode.

  3. Select the replication in the Metadata Explorer.

  4. From the right mouse button menu, choose Replication Properties.

  5. In the Preferences tab, check that the Insert Mode property is set to BulkInsert.  

  6. Adjust the Block Size property to a value between 50 and 100 for best performance.

If the replication is already running, for this change to take effect, you will need to disable, then re-enable the replication.