Cotega Data Sync

Cotega Data Sync is the most efficient way to synchronize data from one Azure SQL databaes to another. Cotega Data Sync makes no changes to your existing SQL database tables and does not require triggers additional tracking columns to provide data synchronization and as a result has very low impact on your Azure SQL database. Since the impact on your local database is so low, you can configure Cotega Data Sync to upload changes at close to real-time rates. Cotega Data Sync provides fast data uploads and can synchronize over 1 Million rows in 3 minutes. Best of all, you can use the Cotega Dashboard to monitor your data sync clients.

How it Works

Cotega Data Sync uses SQL Server Change tracking, an internal service within Azure SQL v12 or higher that efficiently tracks all inserts, updates and deletes made to selected tables. This means that no additional tracking tables, columns or triggers need to be created. SQL Server Change Tracking also has the benefit of having far less of a performance impact on the database then using triggers for change tracking. Since there is little impact on the SQL Server Cotega Data Sync can be set up to to constantly watch for changes and upload them pretty much as they happen, giving you almost real-time updates to Azure SQL database.

Cotega Data Sync uploads your data changes in batches. Although you can alter the batch size to suit your specific needs, we have tested various data sets and have set defaults for the optimum performance. As a result Cotega Data Sync can be over 10 times faster than other data synchronization options. In addition, this also allows Cotega Data Sync to effectively upload extremely large tables into the 100’s of millions of rows.

Monitoring Data Sync Clients

Using the Cotega dashboard, you as an administrator can monitor your Data Sync clients for when they last synchronized and see errors that happened. You can also optionally choose to be notified by email or SMS when issues with data synchronization occur.

Cotega Data Sync Pricing

Cotega Data Sync is available with a paid Cotega subscription.

Getting Started with Cotega Data Sync?

Since Cotega Data Sync is in beta, we need to enable this option for your service. To enable Cotega Data Sync for your account, please contact us with your Cotega account name.