Want to batch copy data from Azure SQL database tables to local SQL Server database?
Using MsSqlCopier, you can batch copy data from Azure SQL database tables to local SQL Server database easily and fast, just a few mouse clicks!
Here you can download and install MsSqlCopier.
Copy data from Azure SQL database tables to local SQL Server database
First, Login to Azure SQL database.
You need choice your database in “Database” list.
Click “Wizard – Tables To Tables” at task dialog.
then show the wizard.
1. Open Source.
2. Open Target.
3. Select tables to copy data.
4. Copy data.
More about MsSqlCopier – the tool to copy Azure SQL database data to local SQL Server database
30-day free trial 
US$95.0 
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.
| Property | in Azure SQL | in SQL Server |
|---|---|---|
| dates | datetime2, date, time | datetime, datetime2, date, time |
Command line
| Side | Command |
|---|---|
| Azure SQL | bcp |
| SQL Server | bcp |
| 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.
