Post reply

do i need replication?

  • October 26, 2008 at 1:18 pm

    #214451

    hello

    For Transfering data from one database to another database automatically

    i use (DBS) and a job ,

    but there is a problem:

    the problem is : in every transfer all of the records in the source table

    transfer to the destination table not only the new records....

    regards

  • October 26, 2008 at 6:48 pm

    #889803

    Quintuple Post :w00t:

    If you only want "new" records, then you have to put some logic in your DTS. Maybe run it once a day and use some date paramater to only get today's data. Transactional replication would probably be a better tool.

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

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