[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