Post reply

Updation of million records - Is this approach helpful - Want suggestion

  • August 31, 2009 at 7:27 am

    #214469

    Hi,

    This is my another post for updation. First of all i want to thank you all for giving me a a direction that Fastet way to update 10 million records. - http://www.sqlservercentral.com/Forums/Topic684049-145-1.aspx

    I worked on the suggestion given by you all and it works fine for me and client.

    Now i have another problem.

    User wants to see all the selected/updated records in grids.

    S/he also want a log file for each and every erroneous record.

    Approach on which i am thinking..........

    1. Select records using for XML or Auto XML

    2. Do all the updation in this XML file.

    3 At last update records in DB using this XML file.

    Why i am not using ADO DataSet's update method because user wants to see all the "To be Updated and Actual Updated" records and a log file for erroneous records.

    Is this XML apporach work fine?

    Please comment and reply.

    I' am waiting for your valuable suggestions.

    Thanks ,

    Mithilesh

    MJ:cool:

  • August 31, 2009 at 9:13 am

    #1046910

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic779884-145-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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