In the wizard 3, I put 2 statements and verified both.
select * from cos_sms where sms_id < '201108280000000000';
select * from cos_sms where mail_id < '201108280000000000';
and then continue to enter targer DB information to insert.
bug1> see the fig 1, that CMT set "full statement by a user" as a table name. The error message says the target table name "select * from cos_sms where sms_id < '201108280000000000'" is invalid. So the user cannot continue the next step.
However the user can fix the table name manually but it doesn;t work well in the final report. It ignores a new table name that the user entered.
bug3> See the fig 2. Although I changed table name correctly, it creates the same table schema twice and failed in the 2nd table. I have checked 2 tables and entire records in both tables were migrated to each of table in the target. Which means there was no "partial data migration" by using SELECT statement.
Since there are many requests from DBA when they has to migrate only part of records or changing the table schema, CMT should support JOIN QUERY, and other SELECT queries to extract partial records from a table.
Current CMT seems not supported this feature at all.