EN
Español
English
Português
    Packages

    The database creation and update scheme is done through the distribution of packages by version. The package module allows you to download the database packages via an FTP server or the local file system (removable disk or USB stick), as well as to register packages manually from local files.

    Types of packages

    The app handles three types of packages:

    • Version: Full version packages of database. They contain the base and incremental schema to carry the database from one version to another.
    • Hotfix: Specific fixes applicable to an installed version. They have a dependency version.
    • PostInstall: Scripts that do not require additional dependencies. They can be run on any installed database version.

    The package grid shows the column PackageType to identify the type of each registered package.

    Downloading packages

    Steps to download a package

    1. Selecting the Database Provider
      At the top of the screen, select the database provider SqlServer.
    2. Select the download type
      The available options are:
    • Incremental: You get the missing packages (new versions) or those that are not available in the storage location.
    • Total: Overwrites existing files.
      1. Select the source of the packages
        The available options are:

    • Remote: The app downloads the packets directly from Aranda’s servers. If network policies require you to go through a proxy to access the Internet, click the Set and record proxy information.

      ![](/adbt/en/assets/images/paquetes2.png)
    • FileSystem: The user manually downloads the SQL packages and saves them locally to a folder called SQL.
      1. Start the download
        Click the Download (Download) to start the download process.

    Download details

    In the download box, you can see the detail of the package with the following data:

    • Version
    • PackageType
    • Supplier
    • Release Date
    • State
    • Dependence
    • Initial scripts
    • Incremental scripts

    If the state is Not found (Not found), the package is unavailable and you need to retry the download.

    At the bottom of the screen, a log of messages is displayed indicating actions that are being performed or errors that may occur during downloading.

    Registering packages from local file

    If you have a package file on your computer, you can register it directly in the application without having to download it from an external server.

    Steps to register a package from local file

    1. On the Packages, click the Set.
    2. Select FileSystem.
    3. Click the Browse and select the directory where the package(s) are located.
    4. The package will appear in the grid with its complete information (version, type, supplier, date).

    ⚐ Note:

    • If the package already exists in the repository (same provider and version), the application will update its information with the data from the selected file.
    • If the file does not correspond to a valid package, the application will display an error message and will not make any changes.

    Package Deletion

    This section describes how to delete packages from the database.

    Steps to delete a package

    1. Select the package: Right-click on the package you want to delete.
    2. Start the removal: From the shortcut menu, select the Delete.
    3. Confirm the action: A confirmation window will appear.
    • Press Yes to proceed with the deletion.
    • Press No or Cancel to cancel the operation.

    Restrictions on Deletion

    If the package you are trying to delete is an intermediate package or has active dependencies, you cannot delete it until those dependencies are resolved.

    When attempting to delete a package in this condition, the application will display an alert window informing of the restrictions.

    ⚐ Note: Be sure to remove packages from highest to lowest version (e.g., first 9.5.46, then 9.5.45, etc.)