Migrate Azure to SQL Server

Want to migrate from Azure to SQL Server ?

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

  • Step by Step, just a few mouse clicks.
  • Create SQL Server tables with auto mapping data types. Create SQL Server indexes.

Download Withdata DBCopier Download DBCopier

Migrate from Azure to SQL Server

Login to Azure -> Login to SQL Server -> Select tables to migrate -> Migrate from Azure to SQL Server

Choose source Azure database and logon.

Migrate Azure to SQL Server - Choose Azure and logon

Choose target SQL Server database and logon.

Migrate Azure to SQL Server - Choose SQL Server and logon

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

migrate from Azure to SQL Server - Task Window

then show the wizard.

1. Open source Azure.

Switch from Azure to SQL Server - Open source database

2. Set “Import Type”.

Migrate from Azure to SQL Server - list target tables

3. Select SQL Server tables to migrate.

Switch from Azure to SQL Server - select tables

4. Migrate from Azure to SQL Server.

Create SQL Server tables. Copy Azure data to SQL Server. Create SQL Server indexes.

Switch from Azure to SQL Server - migrate

FAQ

What is Withdata DBCopier?
How long does it take to migrate from Azure to SQL Server?
Is it safe to migrate from Azure to SQL Server using DBCopier?
Can I migrate from Azure to SQL Server on Linux, Mac OS?

More about Azure to SQL Server converter

See also:

Azure SQL → SQL Server reference

Dialect differences

Both Azure SQL and SQL Server are database servers, so the differences below are dialect-level: the same concept is spelled differently on each side.

Propertyin Azure SQLin SQL Server
datesdatetime2, date, timedatetime, datetime2, date, time

Command line

SideCommand
Azure SQLbcp
SQL Serverbcp
SQL Server (load)bcp, or BULK INSERT
Azure SQL (load)bcp, or BULK INSERT

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.


Posted

in

by