What is the most efficient method to copy a linked server table into a SQL Server Database?



  • I need to copy a table located on a linked server in my database. The Source Table has around 55 million records.

    I have tried the "Select INTO" method (T-SQL codes) but the task fails after running for around 2 hours with a "communication link" error.

    What would be the best method to accomplish this task?



  • Method1: In my experience the fastest method would be:

    1. Copy only the structure of the source to the target.
    2. Dump the table contents to single CVS (TXT) files.
    3. Load the text files with "Load data..."

    If you use NAVICAT software, you can go through all these steps as a wizard.

    Method2: You can use NAVICAT software.

    1. By establishing a connection.

    2. In your connection, go to the database and right-click on the table and select the copy option.

    3. Select the Copy option and paste it in the destination database.

    This method shows you the amount of data transfer as a percentage


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2