Sync data from SQL Server to Azure

by

Want to sync data from SQL Server to Azure?

Try Withdata DBCopier, a SQL Server to Azure converter for Windows, Mac, and Linux, Synchronize SQL Server to Azure, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Synchronize data from SQL Server to Azure

Login to SQL Server and target Azure -> Select source SQL Server tables -> Set target Azure tables -> Sync SQL Server data to Azure

Choose source SQL Server database and logon.

sync SQL Server to Azure - Choose SQL Server and logon

Choose target Azure database and logon.

sync SQL Server to Azure - Choose Azure and logon

Click “Wizard – Import All Tables” at task dialog.

sync from SQL Server to Azure - Task Window

then show the wizard.

1. Select source SQL Server tables to sync.

sync from SQL Server to Azure - Open source database

2. List target Azure tables.

Set “Import Type” to “Replace”, it will do a full synchronization.

sync data from SQL Server to Azure - full synchronization

Or set “Import Type” to “Upsert”, it will do a upsert synchronization.

sync data from SQL Server to Azure - upsert synchronization

3. Select Azure tables to sync.

sync from SQL Server to Azure - select tables

4. Sync SQL Server data to Azure.

sync from SQL Server to Azure - sync

Synchronize data from SQL Server to Azure in command line

Save “SQL Server to Azure” session, then you can:

Set scheduled tasks for synchronizing data from SQL Server to Azure

You can schedule and automate this “SQL Server to Azure” conversion task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “Sync SQL Server to Azure” conversion.
  2. Set scheduled task for “Sync SQL Server to Azure” conversion.

FAQ


More about Withdata DBCopier SQL Server to Azure Converter

See also: