Eplan Platform API
EPLAN API / API Reference / Actions / XPamArticlesSyncAction
In This Topic
    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)
     
    

    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"