I have database on sql 2008 and database with same structure on sql 2000
The data in 2008 version are more actual and I need to synchronize them with 2000.
Is it possable to do it with MERGE statement?
I plan remove all FK and disable all triggers previously and tie 2000 as linked to 2008
and use MERGE after that