Eplan Platform API
EPLAN API / API Reference / Actions / XPamArticlesSyncAction
In This Topic
    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:"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"
       
        XPamArticlesSyncAction
                    /srcdb:"SQL2019|parts_2022|2|Mustermann|12345"
                    /destdb:"SQL2019|parts_old|2|Mustermann|12345"