XPamArticlesSyncAction

In This Topic

Synchronization of articles/parts databases from V2022 to SQL Server V2.9.

Parameter	Description
srcdb	Path or connection string of the source database (V2022) (input parameter, mandatory)
destdb	Connection string of the destination database. Format: server\|catalog\|logintype\|username\|pwd Login type. Possible values are: 0 = Windows authentication 1 = SQL authentication (encrypted password) 2 = SQL authentication (non - encrypted password) username and pwd are optional for logintype = 0. server - name of the server catalog - name of the database username - user name pwd - password for access
opensrcdbshared	If this parameter is 1, the source database is opened shared. Otherwise, the database is opened exclusively (input parameter, optional)
opendestdbshared	If this parameter is 1, the destination database is opened shared. Otherwise, the database is opened exclusively (input parameter, optional)
full	If this parameter is 1, all parts are synchronized. In source database missing parts are deleted in destination database. Otherwise, only changes after the last timestamp are synchronized (input parameter, optional)

Remarks

The first call will synchronize the whole database. All further calls only adjust the changes since the last call.

Example

XPamArticlesSyncAction
/srcdb:"d:\part001.alk"
/destdb:"WIN-DB1\SQLEXPRESS|eplanparts|0"

Parts data synchronization for an Access database:

XPamArticlesSyncAction
/srcdb:"C:\<DataDirectory>\Article\EPLAN\ESS_part001.alk"
/destdb:"C:\<DataDirectory>\Article\EPLAN\ESS_part001.mdb"

Parts data synchronization for SQL databases:

XPamArticlesSyncAction
/srcdb:"WIN-DB1\SQLEXPRESS|parts_2022|0"
/destdb:"WIN-DB1\SQLEXPRESS|parts_old|0"