Check SQL Tools from
http://red-gate.com and SQL Diff from
http://apexsql.com/>
>Recently, I told to do some data migration from a LIVE production system
>to be in synch with a TESTING system of both SQL Server 2000.
>
>Both system will have different schema(different structure, relationship
>and indexes)
>
>I am told to make the LIVE production system to be the same in all aspect
>as the TESTING system.
>
>01) Any ways or advise for me on how to go about doing it ?
>02) Plus, I am told to synch the LIVE system data to the TESTING system.
>The TESTING system had some testing data in it now.
>
>03) I using the MS SQL wizard but it keep reporting of bulk import problem,(as both
>data structure,relationship are different). Even using SQL Data compare and SQL compare
>does not help too(they still cause some relationship to be missing)
>
--sb--