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

Sung-uk Park 20 Reputation points

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 ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,006 questions
{count} votes

Accepted answer
  1. Rahul Randive 4,461 Reputation points Microsoft Employee

    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-

    User's image

    Detailed blog found here-

    Let us know if you need any additional information.

    Thank you!

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Erland Sommarskog 88,621 Reputation points

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

    0 comments No comments

  2. ZoeHui-MSFT 25,861 Reputation points

    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


    Zoe Hui

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

    0 comments No comments