Posted by Yas on 08/16/07 12:15

Hello,

I have 2 tables, Table1 and Table2. I have copied all data from Table1
to Table2.
However Table1 is dynamic it has new rows added and some old rows
modified everyday or every other day...
How can I continue to keep Table2 up to date without always having to
copy everything from Table1?

Basically from now on I would only like to copy new rows or modified
rows in Table1 to Table2 and skip rows that are already present and
have not been modified in Table1. I would like to not do anything for
any rows that were removed in Table1 and continue to keep a copy of
them in Table2.


Is using a DTS package the best way to automate this update of Table2
to make sure Table2 is always up-to-date with Table1?


Thanks for any help or advise :-)

Yas

• Next in forum: Re: MS SQL copy new and modified rows from TABLE1 to TABLE2
• Prev in forum: Problem performing remote queries
• Thread view: MS SQL copy new and modified rows from TABLE1 to TABLE2

[Reply to this message]