If two data sets have the same name in two different DMSII databases (or data sources, from the Client perspective), the DATABridge Client appends the number 1 to the duplicate table name the first time it is encountered. If a table already exists with the duplicate name and the number 1, the DATABridge Client appends the number 2 and so on until a unique table name is created.
For example, if DMSII database A has a data set named PRODUCTS and DMSII database B also has a data set named PRODUCTS, the resulting DATABridge table names would be products and products1.
If you combine this duplicate data set name convention with the convention for naming split tables (when one data set results in more than one table), you can have multiple suffixes for short names.
For example, if you have two data sources with a data set named CUSTOMER, which also generates split tables, the tables are renamed as follows:
Duplicate item names may result in the following cases:
The DATABridge Client handles duplicate item names the same way that it handles duplicate table names.