Post reply

DTS import Failed Out of Memory for Query Result

  • May 15, 2007 at 11:58 pm

    #69007

    Hi all,

    I'm trying to do data migration from Postgres to SQL Server 2000. One particular table import failed with “Out of Memory fir Query Result” error. This particular table go around 8 million records.

    How can I fix this error and import data successfully.

     

    Thanks

    Aranga

     

  • May 16, 2007 at 12:21 am

    #706669

    Hi Aranga,

    I'm not an Postgre guy but this error comes up due to the entire set of records trying to get loaded onto memory. try considering breaking up the transfer into smaller data sets.

    Regards

    Gogula Aryalingam

    (http://sqlserveruniverse.com)

  • May 16, 2007 at 12:46 am

    #706672

    Hi,

    Another thing that I would like to add is that this is not a server-side error. It's an error caused on the client side when the client tries to load all the data at one go (maybe onto limited memory)

    Regards

    Gogula Aryalingam

    (http://sqlserveruniverse.com)

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

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