[thelist] MS sql table sync
Brian Cummiskey
brian at hondaswap.com
Thu Oct 26 09:44:13 CDT 2006
I have a table on a SQL server that needs to be updated to match a table
on another server regularly.
Truncating and full import cannot be done, as it will cause sql errors
to the scripts that will be hitting it at any given time.
Can you help me with a query that will import any new records into the
table, delete anything that's removed from the master, and update
anything that's changed?
Or is there something better built into ms sql 2000 that can do this for me?
Thanks,
Brian
More information about the thelist
mailing list