--- title: "Replicating with SQL Server Using Refresh" slug: "improving-performance-using-refresh-with-sql-server" updated: 2024-03-24T13:45:40Z published: 2024-03-24T13:45:40Z canonical: "skthelp.syniti.com/improving-performance-using-refresh-with-sql-server" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Improving Performance Using Refresh with SQL Server 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](/v1/docs/replication-properties-dialog#preferences-tab) of the [Replication Properties dialog](/v1/docs/replication-properties-dialog). 1. In the Target Connection wizard, when [creating a target connection](/v1/docs/add-target-connection-wizard), select the Microsoft SQL Server .NET Data Provider or the MySQL .NET Data Provider. 2. In the Replication wizard, when [configuring the replication](/v1/docs/replication-wizard), choose **Refresh** as the Replication mode. 3. Select the replication in the Metadata Explorer. 4. From the right mouse button menu, choose [Replication Properties](/v1/docs/replication-properties-dialog). 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](/v1/docs/running-a-replication).