Migrate data from source to destination when names are different
<?xml version="1.0" encoding="UTF-8"?> <scenario> <name>Migrate data from source to destination when names are different</name> <script>dest_table_name</script> <driver>auto</driver> <sources> <source> <name>employee</name> <extract> <sql>select * from employee</sql> </extract> </source> </sources> <destinations> <destination> <name>employee</name> <tablename>new_employee</tablename> <metadata>yes</metadata> </destination> </destinations> </scenario>