Home Forums SQL Server 7,2000 General Importing 5 million rows of data every day? RE: Importing 5 million rows of data every day?

  • i would suggest you add two more new columns to your source table DateCreated and DateModified. first time you dump all the records from source to destination. later you can store the maxdate of datecreated column destination table somewhere and look for records that are added after that date in the source . sameway you can query the source with datemodified and update the corresponding records.

    HTH