Hi,

Recently, I had to do a data migration to change the
following, there are my LIVE Sql2k server(A) and my TESTING sql2k server(B)

01) A and B are having different schema and file structure and data
02) even using tools like Red-Gate Sql data compare and ApexSql diff,
I still face problem in migration the data.
03) I need to ensure that the A file structure are the same as B
and migrate A data into B.

Any one had any advise/help on similar issue that I must do
first/take note of on data migration.

Any help/advise is very much appreciated. Thank u