locked
Difference between Data "Import and Export" and "Restore from backup" RRS feed

  • Question

  • Hi All,

    Could some help us understand the difference between the impact of using Import and Export functionality and Restore from backup in terms of migrating data to a different application <g class="gr_ gr_273 gr-alert gr_gramm gr_run_anim Punctuation multiReplace" data-gr-id="273" id="273">environment.</g> 

    We wanted to understand the impact in terms of Memory, CPU utilisation and does any of these processes uses the concept of locks? 

    We have seen some issue with production application when tried to migrate data with "Import and Export" wizard.

    Regards,

    Krishna.

    Tuesday, October 18, 2016 10:29 AM

All replies

  • There are Two type migration

         a)Inplace 

          b) Side by side migration :-

    Here migration by taking backup and Restore.


    https://www.mssqltips.com/sqlservertip/2168/upgrading-to-sql-server-2008-using-backup-and-restore-method/

    http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html


    Please click Mark As Answer if my post helped.

    Tuesday, October 18, 2016 11:28 AM
  • Import and Export are logical operations, exporting the schema and optionally the data into (essentially) a .zip file. 

    Backup and Restore are physical operations, copying the actual database pages to the backup device. 

    So Backup and Restore are generally faster and more reliable.  But there are scenarios where Import and Export are required.  For instance Azure SQL Database doesn't expose the raw backups.  Also backups can never be restored to a previous version.  Exports can.

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Proposed as answer by Teige Gao Wednesday, October 19, 2016 7:48 AM
    Tuesday, October 18, 2016 11:40 AM