{"type":"doc","content":[{"type":"paragraph","content":[{"text":"This page outlines how to automate the Liquibase Enterprise GUI installation on a Windows machine using a .bat file. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The page also provides a sample build.yml file for running via a GitHub Action.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"This automation performs the following using an install.bat file:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Moves any existing DaticalDB / LiquibaseDesktop installation folder to DaticalDB-YYYY-MM-DD-hh-mm-ss","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Renames the installation files from eg. ","type":"text"},{"text":"DaticalDB-win32.win32.x86_64-8.5.229.jar","type":"text","marks":[{"type":"em"}]},{"text":" to ","type":"text"},{"text":"datical.jar","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"DaticalDBCompositeRepo-8.5.229.zip","type":"text","marks":[{"type":"em"}]},{"text":" to ","type":"text"},{"text":"datical.zip","type":"text","marks":[{"type":"strong"}]},{"text":", and ","type":"text"},{"text":"CustomerEnterpriseLicense.lic","type":"text","marks":[{"type":"em"}]},{"text":" to ","type":"text"},{"text":"datical.lic","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Does a silent install of the GUI using an install_script.xml","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Installs the Datical license","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Installs the Datical drivers on the CLI","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Installs the Datical drivers on the GUI","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Copies the Datical license to the install’s repl folder","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 1: Download necessary installation files and license","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The below necessary files have been downloaded from ","type":"text"},{"type":"inlineCard","attrs":{"url":"http://software.datical.com"}},{"text":" and are located in a ","type":"text"},{"text":"datical_install","type":"text","marks":[{"type":"strong"}]},{"text":" folder on the Windows machine, eg. ","type":"text"},{"text":"C:\\Users\\Administrator\\datical_install","type":"text","marks":[{"type":"code"}]},{"text":". Filenames need to end in .jar, .zip, and .lic.","type":"text"},{"type":"hardBreak"},{"text":"Examples:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"DaticalDB-win32.win32.x86_64-7.XX.XXXX.jar","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"DaticalDBCompositeRepo-7.XX.XXXX.zip","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CustomerEnterpriseLicense.lic","type":"text","marks":[{"type":"strong"}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Ensure there is only one version of the install files located in the datical_install folder.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}},{"type":"strong"}]}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":704,"id":"6a2b6f7f-0ba1-4837-964b-3fcc80cd344f","collection":"contentId-3180036110","type":"file","height":202}}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 2: Create an install_script.xml or customize the following example install_script.xml","type":"text"}]},{"type":"paragraph","content":[{"text":"Install scripts can be generated by performing a manual install and then selecting “Generate an automatic installation script” at the end of the installation.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":732,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":732,"alt":"image-20240709-202020.png","id":"f9a03cfc-b71b-4d68-a62b-de5636c5362b","collection":"contentId-3180036110","type":"file","height":587}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Versions 8.x","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If you are using the below sample install_script.xml, update the references in the below install_script.xml. In the sample below the is set as ","type":"text"},{"text":"C:\\Users\\Administrator\\LiquibaseDesktop","type":"text","marks":[{"type":"code"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make similar adjustments to the nodes below to match the ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Ensure the java path is set correctly.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This file needs to also be placed on the Agent in the ","type":"text"},{"text":"datical_install","type":"text","marks":[{"type":"strong"}]},{"text":" folder. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Alternatively you can check this file into source control along with any build scripts for this automation.","type":"text"}]}]}]}]}]},{"type":"paragraph","content":[{"text":"install_script.xml for versions 8.x","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":"\n\n\n\n\nC:\\Users\\Administrator\\LiquibaseDesktop\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Versions 7.x","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If you are using the below sample install_script.xml, update the if required. Currently set to ","type":"text"},{"text":"C:\\Users\\Administrator\\DaticalDB","type":"text","marks":[{"type":"code"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make similar adjustments to the nodes below to match the ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Ensure the java path is set correctly.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This file needs to also be placed on the Agent in the ","type":"text"},{"text":"datical_install","type":"text","marks":[{"type":"strong"}]},{"text":" folder. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Alternatively you can check this file into source control along with any build scripts for this automation.","type":"text"}]}]}]}]}]},{"type":"paragraph","content":[{"text":"install_script.xml for versions 7.x","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":"\n\n\n\n\nC:\\Users\\Administrator\\DaticalDB\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n","type":"text"}]},{"type":"paragraph"},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":655,"id":"5f9a8e96-79c8-49be-8c21-c3e667f96b6f","collection":"contentId-3180036110","type":"file","height":236}}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 3: Call the following install.bat file","type":"text"}]},{"type":"paragraph","content":[{"text":"The following install.bat file can be called to perform the installation. The following values must be passed to the install.bat:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"home_dir, eg. ","type":"text"},{"text":"C:\\Users\\Administrator","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":"(this needs to be the same in Step 2) ","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"install_files_dir, eg. ","type":"text"},{"text":"C:\\Users\\Administrator\\datical_install","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":"(this needs to be the same as the datical_install directory in Step 1)","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Call the install.bat as: ","type":"text"},{"text":"./install.bat \"C:\\Users\\Administrator\" \"C:\\Users\\Administrator\\datical_install\"","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"codeBlock","content":[{"text":"SET home_dir=%1\nSET install_files_dir=%2\n\nSET product_dir=%home_dir%\\DaticalDB\nSET REPO=jar:file:/%install_files_dir%/datical.zip!/\n\necho 'Home Directory: %home_dir%'\necho 'Product Directory: %product_dir%'\necho 'Install Files Directory: %install_files_dir%'\n\nmove %product_dir% %product_dir%-%DATE:~-4%-%DATE:~4,2%-%DATE:~7,2%-%time:~-11,2%-%time:~-8,2%-%time:~-5,2%\n\nrename %install_files_dir%\\*.lic datical.lic\nrename %install_files_dir%\\*.jar datical.jar\nrename %install_files_dir%\\*CompositeRepo*.zip datical.zip\n\ncd install_files\n\njava -jar %install_files_dir%/datical.jar %install_files_dir%/install_script.xml\n\necho 'Install License'\ncall hammer installLicense %install_files_dir%\\datical.lic\n\necho 'Show License'\ncall hammer show license\n\necho 'Install Drivers for the CLI'\ncall hammer installDrivers %REPO%\n\necho 'Check Drivers for the CLI'\ncall hammer checkDrivers \n\necho 'Install Drivers for the GUI'\n\n%product_dir%\\eclipsec.exe -application org.eclipse.equinox.p2.director ^\n-noSplash ^\n-repository %REPO% ^\n-destination %product_dir% ^\n-installIUs ^\ncom.datical.db.drivers.mssql.feature.feature.group,^\ncom.datical.db.drivers.oracle.feature.feature.group,^\ncom.datical.db.drivers.db2.feature.feature.group,^\ncom.datical.db.drivers.postgresql.feature.feature.group,^\ncom.datical.db.drivers.DaticalJDBC.feature.group\n\n%product_dir%\\eclipsec.exe -application org.eclipse.equinox.p2.director ^\n-noSplash ^\n-repository %REPO% ^\n-destination %product_dir%\\repl ^\n-installIUs ^\ncom.datical.db.drivers.mssql.feature.feature.group,^\ncom.datical.db.drivers.oracle.feature.feature.group,^\ncom.datical.db.drivers.db2.feature.feature.group,^\ncom.datical.db.drivers.postgresql.feature.feature.group,^\ncom.datical.db.drivers.DaticalJDBC.feature.group\n\necho 'Copy license to repl folder for CLI'\ncopy %install_files_dir%\\datical.lic %product_dir%\\repl\n\necho 'Copy license to product folder for GUI'\ncopy %install_files_dir%\\datical.lic %product_dir%","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Sample build.yml file for calling the install.bat script via a GitHub Action:","type":"text"}]},{"type":"codeBlock","content":[{"text":"# This is a basic workflow to help you get started with GitHub Actions\n\nname: liquibase_install\n\n# Controls when the workflow will run\non:\n # Triggers the workflow on push or pull request events but only for the main branch\n push:\n branches:\n - 'main'\n\n # Allows you to run this workflow manually from the Actions tab\n workflow_dispatch:\n\n# A workflow run is made up of one or more jobs that can run sequentially or in parallel\njobs:\n # This workflow contains a single job called \"build\"\n build:\n # The type of runner that the job will run on\n runs-on: [ self-hosted, windows ]\n\n # Steps represent a sequence of tasks that will be executed as part of the job\n steps:\n # Checks-out your repository under $GITHUB_WORKSPACE, so your job can access it\n - uses: actions/checkout@v2\n \n # Runs the Liquibase Install Windows\n - name: Install Liquibase Enterprise (Windows)\n if: runner.os == 'Windows'\n run: |\n $HOME_DIR=$Env:USERPROFILE\n $INSTALL_FILES_DIR=$Env:USERPROFILE + \"\\datical_install\"\n .\\install.bat $HOME_DIR $INSTALL_FILES_DIR ","type":"text"}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"paragraph"}],"version":1}

Browser not supported