XPamArticlesSyncAction

In This Topic

Synchronisation from articles/parts databases from V2022 to SQL-Server V2.9.

Parameter	Description
srcdb	Path or connection string of the source database (V2022) (in)(obligatory)
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 exclusive (in)(optional)
opendestdbshared	If this parameter is 1, the destination database is opened shared. Otherwise, the database is opened exclusive (in)(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 (in)(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:"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:"SQLEXPRESS|parts_2022|0"
/destdb:"SQLEXPRESS|parts_old|0"

Send Feedback