Hi,

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)

Any advise or comment on above data migration issues is very much appreciated.
Thank you