Withdata Software

Copy SQL Server query results to Azure table

Want to transfer data from SQL Server query results to Azure table?

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

Download Withdata DBCopier
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Transfer data from SQL Server query To Azure table

Login to SQL Server and Azure -> Enter source SQL Server query -> Set target Azure table -> Copy SQL Server query data to Azure table

Choose source SQL Server database and logon.

Choose target Azure database and logon.

Click “Convert From Query” at task dialog.

then show the wizard.

1. Set a SQL Server query.

2. Select a destination Azure table and config fields.

3. Preview data.

4. Transfer data from SQL Server query result to Azure table.


More about SQL Server to Azure converter

See also:

SQL Server → Azure SQL reference

Dialect differences

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

Propertyin SQL Serverin Azure SQL
datesdatetime, datetime2, date, timedatetime2, date, time

Command line

SideCommand
SQL Serverbcp
Azure SQLbcp
Azure SQL (load)bcp, or BULK INSERT
SQL Server (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.