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 Copy Tables from the Utility menu on the Trading Partners window.
The Copy Trading Partners Tables window displays.
There must be an ODBC connection to the trading partner databases in order to use this copy function. 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.
The following information must be entered 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 selected, 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 checked, the program copies all of the tables in the trading partner database (wixset.mdb, tp.mdb, and tradstat.m db) 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.
