Data dump from one database table to other table is very slow in Azure SQL Server

[Anonymous]

Hi,

Why it takes around 11 minutes to dump 2.8 million rows from one database table to other table on Azure Sql server?

Do anyone have solution to speed up the performance on Azure Server?

Thanks,

Dhara

[ThWabi]

Hello Dhara,

can you please check if the bulk load component runs without error when you place the "mssql_data.txt" file on the SQL server in a corresponding directory?

Best regards,

Thomas

[Anonymous]

Hi,

Bulk load runs with error file accessing the file.

Thanks,

Dhara

[ThWabi]

Hi Dhara,

I know from our MySQL that there is a setting to allow bulk loads only from a certain directory. Maybe your SQL server has a similar setting in place?

I am not familiar with Azure SQL server, so I have to leave it to other experts.

Best regards,

Thomas