Post reply

linked servers - getting all rows of a table into a temporary table

  • December 4, 2007 at 2:19 pm

    #177106

    Hi experts,

    What is the fastest way to get all the rows of a table from a linked server (a Pervasive database). I then want to insert all those rows into a SQL Server 2000 database table.

    I have a method using cursors but everybody says they are slow.

    Thank you for any helpful comments you can share.

    Warm regards,

    Hope

  • December 4, 2007 at 2:45 pm

    #757143

    additional note...

    Everybody also says to pull all the data into a SQL Server temp table then insert from the temp table into the destination table. How is that faster, do I have to use a cursor to get rowset/resultset from a table in a linked server??

    Any helpful comments are needed.

    Warm regards,

    Hope

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply