Transfer data from multiple similar Azure tables to same SQL Server table without programming

by

Posted on by

Want to transfer data from multiple similar Azure tables to 1 SQL Server table?

Using DBCopier, a native GUI tool, you can transfer data from multiple similar Azure tables to single SQL Server table easily and fast, just a few mouse clicks.

Support Windows, Linux, macOS

Here you can download and install DBCopier.

Transfer data from multiple similar Azure tables To same SQL Server table

Choose source Azure database and logon.

convert Azure data to SQL Server data - Choose Azure and logon

Choose target SQL Server database and logon.

convert Azure data to SQL Server data - Choose SQL Server and logon

Click “Convert Similar Tables” at task dialog.

Import data from multiple similar Azure tables to 1 SQL Server table - Task Window

then show the wizard.

1. Select similar tables.

Convert data from multiple similar Azure tables to 1 SQL Server table - open query results

2. Select a destination table and config fields.

Extract multiple similar Azure tables data to 1 SQL Server table - select table

3. Preview data.

Migrage data from multiple similar Azure tables to 1 SQL Server table - preview

4. Import.

Import data from multiple similar Azure tables to 1 SQL Server table - import

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

More about DBCopier – the tool to copy Azure data to SQL Server

30-day free trial Download DBCopier