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.)
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 select the ODBC Configure … button and use Microsoft Access to set up a DSN.
Copying one or more tables
Highlight a Trade Partner and choose Utilities>Copy Tables from Trading Partners window.
The Copy Trading Partners Tables window displays. The DSN for the current Trade Partner ODBC connection is the source for the table copy.
Enter the DSN connect string for the target database of the trading partner copy,
or
Click Browse and select a data source from the ODBC Data Source Name window.
Select one of the following Trade Agreement copy options:
All - Copy all Trade Agreements – Copy all trade agreements in addition to trading partner tables
None - Copy no Trade Agreements – Copy trading partner tables and no trade agreement tables
Select - Copy selected Trade Agreements – Select the trade agreements you want to include with the trading partner tables
Click OK.
If you choose All or None, a prompt displays indicating that the copy is complete.
It you choose Select, the Trade Agreement window displays. Select the Trade Agreements you want to include in the copy and click OK.