The Copy Trading Partner Tables window allows the user to copy trade partner tables from one database to another database. To copy a trade partner table, follow these steps:
Click the Trade Partner icon and go to the menu bar.
Click to display the Utility menu.
Select Copy Tables…
The Copy Trading Partner Tables window appears.
The Source Trading Partner ODBC Connection field is automatically populated with the Data Source Name given during the system configuration.
Enter the destination database data source name in the Destination Trading Partner ODBC Connection field. You can optionally use the Browse button to locate the destination database. A user identifier (uid) and password (pwd) may be required as shown.
Check the Copy Exported Records Only check box if you want to copy only exported records rather than all records. The items flagged for export in the Trading Partner window will be copied.
Check the Remove Old Records check box to optionally remove all records that exist in the destination TP table.
Click OK.
You can use the ODBC Configure button to define a new
ODBC data source name.
