How about the route of data flow when I execute data copy by Import and Export Wizard ?

Question

If I execute data copy (SQL Server to SQL Server) by wizard of my local SSMS, does data copied via my local pc or directly server to server ?

Is there any Official Document from Microsoft about this situation ?

Answer 1

Hi @Sung-uk Park

When importing or exporting data in Azure SQL Database, the data is not copied via your local PC. Instead, the import/export operation is performed directly from the server to server.

The exact process for importing and exporting data can vary depending on the specific method being used, such as the Azure portal, SQLPackage or command-line.

However, in general, the data is first extracted from the source database, and transferred to the destination database.

Example if you use SQLPackage.exe method to import the data, then it will be store in the local PC first.

Here is a syntax-

Detailed blog found here- https://techcommunity.microsoft.com/t5/azure-database-support-blog/using-sqlpackage-to-import-or-export-sql-server-and-azure-sql-db/ba-p/368861

Let us know if you need any additional information.

Thank you!

Answer 2

Data will travel through you local machine. It's not server to server.

Answer 3

Hi @Sung-uk Park,

SQL Server Import and Export Wizard is a simple way to copy data from a source to a destination.

The wizard uses SQL Server Integration Services (SSIS) to copy data. SSIS is a tool for extracting, transforming, and loading data (ETL). The pages of the wizard use some of the language of SSIS.

Check it out here: SQL Server Import and Export Wizard

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.