Automic Workload Automation

  • Private Community

  • 1.  Move Automic Engine database on other Windows server

    Posted Nov 15, 2018 12:57 PM

    Hi All,

     

    How can we move Automic Engine database on other Windows server ?

     

    Thank you in advance for your help.

     

    Kind regards,

    Adriana



  • 2.  Re: Move Automic Engine database on other Windows server

    Broadcom Employee
    Posted Nov 15, 2018 01:10 PM

    The Automation Engine ucsrv.ini file has the SQLDRIVERCONNECT string. In that string you have the DSN=. That will reflect the entry in the ODBC for the connection to the database. The ODBC Data Source Admin connection would need to be updated and reflect the new server that hosts the database. You can read more about this below:

     

    https://docs.automic.com/documentation/webhelp/english/AWA/12.2/DOCU/12.2/AWA%20Guides/help.htm#AWA/Admin/admin_CreatingODBCDataSource.htm?



  • 3.  Re: Move Automic Engine database on other Windows server

    Posted Nov 15, 2018 02:09 PM

    Thank you for your answer.

    Should we use utilities AE DB Unload and AE DB Load ?

     

    Thank you,

    Adriana



  • 4.  Re: Move Automic Engine database on other Windows server

    Broadcom Employee
    Posted Nov 15, 2018 02:19 PM

    You could use the DB Unload and choose option 'Export all data' and then load it into another database with the DB Load utility. SQL also has tools to move a database. 



  • 5.  Re: Move Automic Engine database on other Windows server

    Posted Nov 15, 2018 02:33 PM

    Thank you