ECMap allows you to copy all or selected tables in the trading partner database. (The trading partner database includes the company, trading partner, and trade agreement tables.) To copy one or more tables, choose Utility | Copy Tables from the Trading Partners window.
To use this copy function, there must be an ODBC connection to the trading partner databases. If you are using Dbase or Paradox tables, you may not have a DSN that points to the database and must create one. Since both DBase and Paradox are ODBC-compliant, you can click the ODBC Configure … button and use Microsoft Access to set up a DSN.
You must enter this information on the Copy Trading Partner Tables window:
Source Trading Partner ODBC Connection – is the DSN pointing to the database being copied.
Destination Trading Partner ODBC Connection – is the DSN pointing to the database that is being created by the copy process.
When the Copy Exported Records Only check box is checked, the program copies records only for those trading partners that had the Export button checked on the General tab of the Trading Partners window when they were set up. When this button is not selected, the program copies all of the tables in the trading partner database (wixset.mdb, tp.mdb, and tradstat.mdb) for all trading partners.
When Remove Old Records is checked, the program deletes existing records in the destination database and copies the records from the source database to the destination database. When Remove Old Records is not checked and the program finds existing records in the destination database, the copy process is not executed. You do not receive a message.