Comparing rows in loop

Results 1 to 2 of 2

Thread: Comparing rows in loop

  1. #1
    Join Date
    Dec 1969

    Default Comparing rows in loop

    I have two table comparison of two different Databases(One is on Internet and one is local). I want to check that whether any of the row is modified, added or deleted on the Internet Database table, accordingly i want to make changes in the local one. How can i do that.<BR><BR>I am using ASP as front end tool.<BR><BR>How should i check for change in any of the field of any row in the table of 5000 data fields.

  2. #2
    Join Date
    Dec 1969

    Default RE: Comparing rows in loop

    Ideally you&#039;d create triggers on the INSERT UPDATE DELETE, which take a copy of the SQLs statements performed and store them in a separate table, the remote db just works through this table and performs the sql statements in it. This is an efficent way as your are only transferring sql not bulk data.<BR><BR>Oh, I&#039;ve just re-invented SQL Replication !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts