Search code examples
sqlimportselect-intosql-import-wizard

Select into VS Import and export wizard in sql server

In sql server, From my desktop I connected to the server. And I want to move a data from a database to another. I have used both select into and import wizard. But import wizard seems to be slow. Why?

Is there any methodology changes for transferring data ?

Solution

  • Select into is a SQL query, and it is executed directly.
    Import and Export Wizard is a tool which invokes Integration Services (SSIS).
    Wizard is slow, but can use various data sources

    More about export/import wizard
    https://msdn.microsoft.com/en-US/en-en/library/ms141209.aspx
    Topic about select into and export/import wizard
    https://social.msdn.microsoft.com/forums/sqlserver/en-US/e0524b2a-0ea4-43e7-b74a-e9c7302e34e0/super-slow-performance-while-using-import-export-wizard