Data Migration Tool Usage instructions

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.