1. What issues are resolved?
A, when we do ERP upgrade, many of the old personalized fields or tables are migrated to the new library,
Steps are generally compared with datacompare (due to the large ERP cubby, not necessarily able to load, but also need a bunch of settings).
The generated fields are also not inserted into the Data_dict,def_table,def_table table, and no description is generated. Some people may not use this tool directly. This consumes time to do some repetitive work, wasting energy.
This tool supports all automated builds and supports some fields that do not require synchronization, and can be automatically removed
2. How do I use it? 2.1 Open
Enter the personal station, open the Data Migration tool (client tools only support IE open).
2.2 Configuring the 2.2.1 Database configuration (ctrl+p)
The source library represents the old ERP database, and the target represents the new ERP database.
2.2.2 Configuration generate SQL Output directory
2.2.3 Configuring the Tables to synchronize
For example, to synchronize the P_project table while excluding the Projguid and Projname fields is p_project| Projguid,projname
P_project All sync is:p_project
synchronize multiple tables with; Intervals such as: P_project; P_room
3. Concluding remarks
If you find it useful, please turn over your mail at the company. For more people to use. Have any questions you can leave a message on this blog. Or send me an e-mail
Data Migration Tool Usage instructions