### Navigation Data Structure (JavaScript)

Source: https://docs.devart.com/devops-automation-for-sql-server/getting-started/requirements.html

Represents the hierarchical navigation structure for the product documentation. It includes sections like 'Get started' with links to installation guides, plugin setup, and benefits for different user roles. This data is likely used to render the site's navigation menu.

```javascript
rawNavData = [
  {
    legacyId: 'Getstarted',
    title: 'Get started',
    items: [
      {
        legacyId: 'InstalldbForgeDevOpsAutomationcomponents',
        href: "/devops-automation-for-sql-server/getting-started/installing.html",
        title: "Install dbForge DevOps Automation components",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstalltheAzureDevOpsPlugin',
        href: "/devops-automation-for-sql-server/getting-started/install-azure-devops-plugin.html",
        title: "Install the Azure DevOps Plugin",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstalltheBambooPlugin',
        href: "/devops-automation-for-sql-server/getting-started/install-bamboo-plugin.html",
        title: "Install the Bamboo Plugin",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstalltheTeamCityPlugin',
        href: "/devops-automation-for-sql-server/getting-started/install-teamcity-plugin.html",
        title: "Install the TeamCity Plugin",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstalltheJenkinsPlugin',
        href: "/devops-automation-for-sql-server/getting-started/install-jenkins-plugin.html",
        title: "Install the Jenkins Plugin",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'dbForgeDevOpsAutomationbenefits',
        href: "/devops-automation-for-sql-server/getting-started/devops-automation-benefits.html",
        title: "dbForge DevOps Automation benefits",
        subcategory: 'Benefits of dbForge DevOps Automation',
        filePath: ''
      },
      {
        legacyId: 'ForDatabaseDevelopers',
        href: "/devops-automation-for-sql-server/getting-started/benefits-for-database-developers.html",
        title: "For Database Developers",
        subcategory: 'Benefits of dbForge DevOps Automation',
        filePath: ''
      },
      {
        legacyId: 'ForDatabaseAdministrators',
        href: "/devops-automation-for-sql-server/getting-started/benefits-for-dbas.html",
        title: "For Database Administrators",
        subcategory: 'Benefits of dbForge DevOps Automation',
        filePath: ''
      },
      {
        legacyId: 'ForQualityAssuranceSpecialists',
        href: "/devops-automation-for-sql-server/getting-started/benefits-for-qas.html",
        title: "For Quality Assurance Specialists",
        subca
      }
    ]
  }
];
```

--------------------------------

### Install SqlPackage CLI and .NET Templates

Source: https://docs.microsoft.com/en-us/sql/ssdt/how-to-create-a-new-database-project

Installs the SqlPackage command-line interface and the Microsoft.Build.Sql.Templates for creating SDK-style SQL projects.

```bash
dotnet tool install -g Microsoft.SqlPackage

dotnet new install Microsoft.Build.Sql.Templates
```

--------------------------------

### Command-Line Installation Examples for dotConnect for DB2

Source: https://docs.devart.com/dotconnect/db2/installation.html

Provides examples of command-line arguments for installing and uninstalling dotConnect for DB2. These commands allow for silent, minimal, or custom installations.

```bash
// Minimal type installation (runtime assemblies and machine.config registration)
"installer.exe" /TYPE=COMPACT /VERYSILENT /NOICONS

// Uninstall command
"C:\Program Files\Devart\dotConnect\DB2\Uninstall\unins000.exe" /VERYSILENT /NOFEEDBACK
```

--------------------------------

### Start Azure Data Studio in Windows Subsystem for Linux (WSL)

Source: https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

Starts Azure Data Studio from a WSL terminal when installed on Windows. It requires specifying the full path to the executable, typically located within the user's AppData folder. The user name needs to be substituted in the path.

```bash
/mnt/c/Users/<your user name>/AppData/Local/Programs/Azure Data Studio/azuredatastudio.exe
```

--------------------------------

### Install Azure Data Studio on Linux using .tar.gz

Source: https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

Installs Azure Data Studio on Ubuntu/Debian by downloading a .tar.gz file, extracting it, and updating the PATH environment variable. It also includes commands for starting the application and installing necessary dependencies like libxss1, libgconf-2-4, and libunwind8.

```bash
cd ~
cp ~/Downloads/azuredatastudio-linux-<version string>.tar.gz ~
tar -xvf ~/azuredatastudio-linux-<version string>.tar.gz
echo 'export PATH="$PATH:~/azuredatastudio-linux-x64"' >> ~/.bashrc
source ~/.bashrc
azuredatastudio
```

```bash
sudo apt-get install libxss1 libgconf-2-4 libunwind8
```

--------------------------------

### List Installed Software (Debian/Ubuntu)

Source: https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

This command lists all installed software packages on Debian-based systems like Ubuntu or Debian. The output is piped to 'less' for easier navigation.

```bash
sudo dpkg --list | less
```

--------------------------------

### Getting Help with dbForge Installer Parameters

Source: https://docs.devart.com/studio-for-mysql/getting-started/installing-from-the-command-line.html

This command shows how to retrieve a list of all available parameters for the dbForge installer. Running the executable with `/help` or `/?` in the Command Prompt will display detailed usage information, which is essential for advanced command-line installations.

```bash
dbforgemysql.exe /help
```

--------------------------------

### Install Azure Data Studio using winget on Windows

Source: https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

This command installs Azure Data Studio using the Windows Package Manager CLI (winget). Ensure you have winget installed on your system. This method is straightforward for users familiar with command-line package management.

```shell
winget install "azure data studio"
```

--------------------------------

### JavaScript Navigation Data Structure

Source: https://docs.devart.com/studio-for-mysql/

Represents the navigation structure for the 'dbForge Studio for MySQL' product. It includes hierarchical data for sections like 'Get started', with sub-items detailing requirements, installation, and Linux/macOS usage. Each item contains a URL, title, and file path.

```javascript
rawNavData = [
  {
    legacyId: 'Getstarted',
    title: 'Get started',
    items: [
      {
        legacyId: 'Requirementsandcompatibility',
        href: "/studio-for-mysql/getting-started/requirements.html",
        title: "Requirements and compatibility",
        subcategory: 'Skip',
        filePath: 'Get started/Requirements and Compatibility'
      },
      {
        legacyId: 'HowtoinstalldbForgeStudio',
        href: "/studio-for-mysql/getting-started/installing.html",
        title: "How to install dbForge Studio",
        subcategory: 'Installation',
        filePath: 'Get started/Installation/How to install dbForge Studio'
      },
      {
        legacyId: 'Installationfromthecommandline',
        href: "/studio-for-mysql/getting-started/installing-from-the-command-line.html",
        title: "Installation from the command line",
        subcategory: 'Installation',
        filePath: 'Get started/Installation/Installation from the command line'
      },
      {
        legacyId: 'Copyrightinformation',
        href: "/studio-for-mysql/getting-started/copyright.html",
        title: "Copyright information",
        subcategory: 'Skip',
        filePath: 'Get started/Copyright information'
      },
      {
        legacyId: 'HowtoinstalldbForgeStudioonLinuxmacOS',
        href: "/studio-for-mysql/getting-started/how-to-install-dbforge-studio-linux-mac.html",
        title: "How to install dbForge Studio on Linux & macOS",
        subcategory: 'How to run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/How to install dbForge Studio on Linux & macOS'
      },
      {
        legacyId: 'ScenariobasedinstallationofdbForgeStudioviaCrossOver',
        href: "/studio-for-mysql/getting-started/scenario-based-installation.html",
        title: "Scenario-based installation of dbForge Studio via CrossOver",
        subcategory: 'How to run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/Scenario-based installation of dbForge Studio via CrossOver'
      },
      {
        legacyId: 'ManualinstallationofdbForgeStudioviaCrossOver',
        href: "/studio-for-mysql/getting-started/manual-installation.html",
        title: "Manual installation of dbForge Studio via CrossOver",
        subcategory: 'How to run dbForge Studio on Linux & m'
      }
    ]
  }
];
```

--------------------------------

### Install SQL Server PowerShell Module Guide

Source: https://blog.devart.com/category/how-to

Provides a step-by-step guide for installing the SQL Server PowerShell module. This is essential for automating and managing SQL Server instances using PowerShell.

```powershell
Step-by-Step Guide to Installing the SQL Server PowerShell Module
```

--------------------------------

### Install Azure Data Studio on Ubuntu/Debian using DEB

Source: https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

Installs Azure Data Studio on Ubuntu or Debian using a .deb package. Requires dpkg package manager and installs dependencies like libunwind8 if missing.

```shell
cd ~
sudo dpkg -i ./Downloads/azuredatastudio-linux-<version string>.deb
azuredatastudio
sudo apt-get install libunwind8
```

--------------------------------

### Interactive Command-Line Installation for dbForge Studio for MySQL

Source: https://docs.devart.com/studio-for-mysql/getting-started/installing-from-the-command-line.html

This snippet demonstrates how to initiate the interactive installation of dbForge Studio for MySQL from the command line. It requires navigating to the directory containing the installer and then executing it. This will launch the Installation Wizard for manual configuration.

```bash
cd C:\\Downloads
dbforgemysql.exe
```

--------------------------------

### JavaScript: Navigation Data Structure

Source: https://docs.devart.com/studio-for-oracle/designing-databases/creating-db-diagram.html

Represents navigation data for the dbForge Studio for Oracle documentation, organized into sections like 'Get started' with subcategories for installation and platform-specific guides.

```javascript
rawNavData = [
  {
    legacyId: 'Getstarted',
    title: 'Get started',
    items: [
      {
        legacyId: 'CopyrightInformation',
        href: "/studio-for-oracle/getting-started/copyright-info.html",
        title: "Copyright Information",
        subcategory: 'Skip',
        filePath: ''
      },
      {
        legacyId: 'RequirementsandCompatibility',
        href: "/studio-for-oracle/getting-started/requirements.html",
        title: "Requirements and Compatibility",
        subcategory: 'Skip',
        filePath: ''
      },
      {
        legacyId: 'HowtoinstalldbForgeStudio',
        href: "/studio-for-oracle/getting-started/installing-guide.html",
        title: "How to install dbForge Studio",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstallationfromtheCommandLine',
        href: "/studio-for-oracle/getting-started/installing-from-the-command-line.html",
        title: "Installation from the Command Line",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstallationOverview',
        href: "/studio-for-oracle/getting-started/how-to-install-dbforge-studio-linux-mac.html",
        title: "Installation Overview",
        subcategory: 'How to Run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/Installation Overview'
      },
      {
        legacyId: 'InstalltheStudioonUbuntu',
        href: "/studio-for-oracle/getting-started/install-dbforge-studio-on-ubuntu-with-wine.html",
        title: "Install the Studio on Ubuntu",
        subcategory: 'How to run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using Wine/Install the Studio on Ubuntu'
      },
      {
        legacyId: 'ManualInstallationofdbForgeStudioviaCrossOver',
        href: "/studio-for-oracle/getting-started/manual-installation.html",
        title: "Manual Installation of dbForge Studio via CrossOver",
        subcategory: 'How to Run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/Manual Installation of dbForge Studio via CrossOver'
      },
      {
        legacyId: 'CommandLineModeonLinux',
        href: "/studio-for-oracle/getting-started/command-line-mode-linux.html",
        title: "Command-Line Mode on Linux",
        subcategory:
      }
    ]
  }
];
```

--------------------------------

### JavaScript Array for Navigation Data

Source: https://docs.devart.com/studio-for-oracle/exporting-and-importing-data/data-import-overview.html

Contains the structured navigation data for the documentation. It includes categories like 'Get started' with sub-items for copyright information, requirements, installation guides, and command-line operations on Linux.

```javascript
rawNavData = [
  {
    legacyId: 'Getstarted',
    title: 'Get started',
    items: [
      { legacyId: 'CopyrightInformation', href: "/studio-for-oracle/getting-started/copyright-info.html", title: "Copyright Information", subcategory: 'Skip', filePath: '' },
      { legacyId: 'RequirementsandCompatibility', href: "/studio-for-oracle/getting-started/requirements.html", title: "Requirements and Compatibility", subcategory: 'Skip', filePath: '' },
      { legacyId: 'HowtoinstalldbForgeStudio', href: "/studio-for-oracle/getting-started/installing-guide.html", title: "How to install dbForge Studio", subcategory: 'Installation', filePath: '' },
      { legacyId: 'InstallationfromtheCommandLine', href: "/studio-for-oracle/getting-started/installing-from-the-command-line.html", title: "Installation from the Command Line", subcategory: 'Installation', filePath: '' },
      { legacyId: 'InstallationOverview', href: "/studio-for-oracle/getting-started/how-to-run-dbforge-studio-on-linux-mac.html", title: "Installation Overview", subcategory: 'How to Run dbForge Studio on Linux & macOS', filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/Installation Overview' },
      { legacyId: 'InstalltheStudioonUbuntu', href: "/studio-for-oracle/getting-started/install-dbforge-studio-on-ubuntu-with-wine.html", title: "Install the Studio on Ubuntu", subcategory: 'How to run dbForge Studio on Linux & macOS', filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using Wine/Install the Studio on Ubuntu' },
      { legacyId: 'ManualInstallationofdbForgeStudioviaCrossOver', href: "/studio-for-oracle/getting-started/manual-installation.html", title: "Manual Installation of dbForge Studio via CrossOver", subcategory: 'How to Run dbForge Studio on Linux & macOS', filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/Manual Installation of dbForge Studio via CrossOver' },
      { legacyId: 'CommandLineModeonLinux', href: "/studio-for-oracle/getting-started/command-line-mode-linux.html", title: "Command-Line Mode on Linux", subcategory: 'How to Run dbForg'
    ]
  }
];
```

--------------------------------

### Install SQL Complete via Command Line

Source: https://docs.devart.com/sqlcomplete/getting-started/installing.html

Demonstrates how to navigate to the installer directory and execute the SQL Complete installer from the command line. Supports silent and very silent installation modes.

```shell
cd C:\Downloads
sqlcompletesql.exe
sqlcompletesql.exe /silent
sqlcompletesql.exe /verysilent
```

--------------------------------

### Navigation Data Structure for dbForge Studio for MySQL

Source: https://docs.devart.com/studio-for-mysql/connecting-to-db/creating-ssh-connection.html

Structures the navigation menu for the dbForge Studio for MySQL documentation. It includes main sections like 'Get started' with sub-items for requirements, installation, and platform-specific guides.

```javascript
rawNavData = [
  {
    legacyId:'Getstarted',
    title: 'Get started',
    items: [
      {
        legacyId:'Requirementsandcompatibility',
        href:"/studio-for-mysql/getting-started/requirements.html",
        title:"Requirements and compatibility",
        subcategory: 'Skip',
        filePath: 'Get started/Requirements and compatibility'
      },
      {
        legacyId:'HowtoinstalldbForgeStudio',
        href:"/studio-for-mysql/getting-started/installing.html",
        title:"How to install dbForge Studio",
        subcategory: 'Installation',
        filePath: 'Get started/Installation/How to install dbForge Studio'
      },
      {
        legacyId:'Installationfromthecommandline',
        href:"/studio-for-mysql/getting-started/installing-from-the-command-line.html",
        title:"Installation from the command line",
        subcategory: 'Installation',
        filePath: 'Get started/Installation/Installation from the command line'
      },
      {
        legacyId:'Copyrightinformation',
        href:"/studio-for-mysql/getting-started/copyright.html",
        title:"Copyright information",
        subcategory: 'Skip',
        filePath: 'Get started/Copyright information'
      },
      {
        legacyId:'HowtoinstalldbForgeStudioonLinuxmacOS',
        href:"/studio-for-mysql/getting-started/how-to-install-dbforge-studio-linux-mac.html",
        title:"How to install dbForge Studio on Linux & macOS",
        subcategory: 'How to run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/How to install dbForge Studio on Linux & macOS'
      },
      {
        legacyId:'ScenariobasedinstallationofdbForgeStudioviaCrossOver',
        href:"/studio-for-mysql/getting-started/scenario-based-installation.html",
        title:"Scenario-based installation of dbForge Studio via CrossOver",
        subcategory: 'How to run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/Scenario-based installation of dbForge Studio via CrossOver'
      },
      {
        legacyId:'ManualinstallationofdbForgeStudioviaCrossOver',
        href:"/studio-for-mysql/getting-started/manual-installation.html",
        title:"Manual installation of dbForge Studio via CrossOver",
        subcategory: 'How to run dbForge Studio on Linux & ma'
      }
    ]
  }
];
```

--------------------------------

### Install SQL Complete using PowerShell Script

Source: https://docs.devart.com/sqlcomplete/getting-started/installing.html

Illustrates how to initiate the SQL Complete installation process using PowerShell's Start-Process cmdlet. This includes specifying the installer path and command-line arguments, such as '/verysilent' for unattended installation.

```powershell
Start-Process -FilePath $installerPath -ArgumentList $arguments -Wait
Start-Process -FilePath "D:\sqlcompletesql.exe" -ArgumentList "/verysilent" -Wait
```

--------------------------------

### Navigation Data Structure

Source: https://docs.devart.com/studio-for-oracle/working-with-schema-objects/procedures-and-functions.html

A JavaScript array representing the navigation structure for the documentation. It organizes content by sections like 'Get started' with nested items detailing specific topics such as copyright information, system requirements, and installation guides for different operating systems and methods.

```javascript
rawNavData = [
  {
    legacyId: 'Getstarted',
    title: 'Get started',
    items: [
      {
        legacyId: 'CopyrightInformation',
        href: "/studio-for-oracle/getting-started/copyright-info.html",
        title: "Copyright Information",
        subcategory: 'Skip',
        filePath: ''
      },
      {
        legacyId: 'RequirementsandCompatibility',
        href: "/studio-for-oracle/getting-started/requirements.html",
        title: "Requirements and Compatibility",
        subcategory: 'Skip',
        filePath: ''
      },
      {
        legacyId: 'HowtoinstalldbForgeStudio',
        href: "/studio-for-oracle/getting-started/installing-guide.html",
        title: "How to install dbForge Studio",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstallationfromtheCommandLine',
        href: "/studio-for-oracle/getting-started/installing-from-the-command-line.html",
        title: "Installation from the Command Line",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstallationOverview',
        href: "/studio-for-oracle/getting-started/how-to-install-dbforge-studio-linux-mac.html",
        title: "Installation Overview",
        subcategory: 'How to Run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/Installation Overview'
      },
      {
        legacyId: 'InstalltheStudioonUbuntu',
        href: "/studio-for-oracle/getting-started/install-dbforge-studio-on-ubuntu-with-wine.html",
        title: "Install the Studio on Ubuntu",
        subcategory: 'How to run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using Wine/Install the Studio on Ubuntu'
      },
      {
        legacyId: 'ManualInstallationofdbForgeStudioviaCrossOver',
        href: "/studio-for-oracle/getting-started/manual-installation.html",
        title: "Manual Installation of dbForge Studio via CrossOver",
        subcategory: 'How to Run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/Manual Installation of dbForge Studio via CrossOver'
      },
      {
        legacyId: 'CommandLineModeonLinux',
        href: "/studio-for-oracle/getting-started/command-line-mode-linux.html",
        title: "Command-Line Mode on Linux",
        subcategory: 'How to Run db
    ]
  }
];
```

--------------------------------

### Setup InterBase Service Script

Source: https://docwiki.embarcadero.com/InterBase/2020/en/Installation,_Registration,_and_Licensing_Information

This script is used to set up and manage InterBase as a service. It requires the InterBase installation path and the instance name as arguments. Ensure the script is copied and edited to reflect the correct installation path before execution.

```bash
/usr/interbase/examples/ibservice.sh -s[etup] <interbase> <instance_name>
```

```bash
sudo ./ibservice.sh -s /opt/interbase_ems ems
```

--------------------------------

### InterBase Installation Configuration Properties

Source: https://docwiki.embarcadero.com/InterBase/2020/en/Installation,_Registration,_and_Licensing_Information

Examples of .props files used for configuring InterBase installations. These files specify settings like INSTANCE_NAME, COMPONENTS, and UPDATE_CLIENT for different installation scenarios, including server/client combinations and client-only setups.

```properties
INSTANCE_NAME=ib2020_64
COMPONENTS=A
```

```properties
INSTANCE_NAME=ib2020_64
COMPONENTS=A
UPDATE_CLIENT=
```

```properties
INSTANCE_NAME=ib2020_64
COMPONENTS=B
UPDATE_CLIENT=
```

```properties
MAINDIR=C:\Program Files\MyCompany\MyApp\bin
COMPONENTS=B
ARCH=64
```

```properties
MAINDIR=C:\Temp\IB2020_Update7_files
COMPONENTS=C
```

--------------------------------

### sqlcmd (Go) Usage and Examples

Source: https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility

This snippet demonstrates the command-line usage and provides examples for the Go-based sqlcmd variant. It covers operations like installing/creating SQL Server instances, querying data, managing configurations, and opening tools like Azure Data Studio (ADS).

```bash
sqlcmd create mssql --accept-eula --using https://aka.ms/AdventureWorksLT.bak
sqlcmd open ads
sqlcmd query "SELECT @@version"
sqlcmd delete
sqlcmd config view
sqlcmd config cs
```

--------------------------------

### Navigation Data Structure

Source: https://docs.devart.com/devops-automation-for-sql-server/concepts/database-ci-with-devart-tools.html

This JavaScript array represents the navigation structure for the documentation. It is organized into sections like 'Get started', with nested items for specific topics such as installation guides for various plugins and descriptions of product benefits for different user roles. Each item includes an ID, title, and a link to the relevant HTML page.

```javascript
rawNavData = [
  {
    legacyId: 'Getstarted',
    title: 'Get started',
    items: [
      {
        legacyId: 'InstalldbForgeDevOpsAutomationcomponents',
        href: "/devops-automation-for-sql-server/getting-started/installing.html",
        title: "Install dbForge DevOps Automation components",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstalltheAzureDevOpsPlugin',
        href: "/devops-automation-for-sql-server/getting-started/install-azure-devops-plugin.html",
        title: "Install the Azure DevOps Plugin",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstalltheBambooPlugin',
        href: "/devops-automation-for-sql-server/getting-started/install-bamboo-plugin.html",
        title: "Install the Bamboo Plugin",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstalltheTeamCityPlugin',
        href: "/devops-automation-for-sql-server/getting-started/install-teamcity-plugin.html",
        title: "Install the TeamCity Plugin",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'InstalltheJenkinsPlugin',
        href: "/devops-automation-for-sql-server/getting-started/install-jenkins-plugin.html",
        title: "Install the Jenkins Plugin",
        subcategory: 'Installation',
        filePath: ''
      },
      {
        legacyId: 'dbForgeDevOpsAutomationbenefits',
        href: "/devops-automation-for-sql-server/getting-started/devops-automation-benefits.html",
        title: "dbForge DevOps Automation benefits",
        subcategory: 'Benefits of dbForge DevOps Automation',
        filePath: ''
      },
      {
        legacyId: 'ForDatabaseDevelopers',
        href: "/devops-automation-for-sql-server/getting-started/benefits-for-database-developers.html",
        title: "For Database Developers",
        subcategory: 'Benefits of dbForge DevOps Automation',
        filePath: ''
      },
      {
        legacyId: 'ForDatabaseAdministrators',
        href: "/devops-automation-for-sql-server/getting-started/benefits-for-dbas.html",
        title: "For Database Administrators",
        subcategory: 'Benefits of dbForge DevOps Automation',
        filePath: ''
      },
      {
        legacyId: 'ForQualityAssuranceSpecialists',
        href: "/devops-automation-for-sql-server/getting-started/benefits-for-qas.html",
        title: "Fo"
      }
    ]
  }
];
```

--------------------------------

### Install Docker Engine on Ubuntu using apt repository

Source: https://blog.devart.com/php-connect-to-sql-server.html

Steps to set up the Docker apt repository and install Docker Engine, Docker CLI, containerd.io, and Docker Compose plugin on Ubuntu. Verifies installation with a hello-world container.

```bash
sudo apt-get update
sudo apt-get install ca-certificates curl
sudo install -m 0755 -d /etc/apt/keyrings
sudo curl -fsSL https://download.docker.com/linux/ubuntu/gpg -o /etc/apt/keyrings/docker.asc
sudo chmod a+r /etc/apt/keyrings/docker.asc
echo \
  "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/ubuntu \
  $(. /etc/os-release && echo "$VERSION_CODENAME") stable" | \
  sudo tee /etc/apt/sources.list.d/docker.list > /dev/null
sudo apt-get update
```

```bash
sudo apt-get install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin
```

```bash
sudo docker run hello-world
```

--------------------------------

### Get Azure Environment Details using PowerShell

Source: https://learn.microsoft.com/en-us/powershell/azure/get-started-azureps

This cmdlet retrieves information about the current Azure environment, such as available clouds and endpoints. It's useful for understanding your Azure setup. Requires the Azure PowerShell module.

```powershell
Get-AzEnvironment
```

--------------------------------

### Create Portable dbForge Studio for MySQL with Innoextract

Source: https://docs.devart.com/studio-for-mysql/getting-started/installing.html

Extracts the installer of dbForge Studio for MySQL to create a portable version. This involves navigating to the desired directory and using the innoextract utility with the installer file path. An optional '-d' flag can specify the output directory directly.

```bash
cd D:\PortableApps
D:\innoextract\innoextract.exe D:\Downloads\dbforgemysql.exe
# Optional with -d flag:
D:\innoextract\innoextract.exe -d D:\PortableApps\ D:\Downloads\dbforgemysql.exe
```

--------------------------------

### JavaScript Navigation Data Structure

Source: https://docs.devart.com/sqlcomplete/getting-started/installing.html

This JavaScript array defines the navigation structure for the SQL Complete documentation. It organizes content into sections like 'Get started' with links to specific articles and their metadata.

```javascript
rawNavData = [
  {
    legacyId: 'Getstarted',
    title: 'Get started',
    items: [
      {
        legacyId: 'Boostcodingproductivity',
        href: "/sqlcomplete/getting-started/boost-coding-productivity.html",
        title: "Boost coding productivity",
        subcategory: 'What you can achieve with SQL Complete',
        filePath: ''
      },
      {
        legacyId: 'Automateprocesses',
        href: "/sqlcomplete/getting-started/automate-processes.html",
        title: "Automate processes",
        subcategory: 'What you can achieve with SQL Complete',
        filePath: ''
      },
      {
        legacyId: 'Reusecodemodules',
        href: "/sqlcomplete/getting-started/reuse-code-modules.html",
        title: "Reuse code modules",
        subcategory: 'What you can achieve with SQL Complete',
        filePath: ''
      },
      {
        legacyId: 'Improvecodequality',
        href: "/sqlcomplete/getting-started/improve-code-quality.html",
        title: "Improve code quality",
        subcategory: 'What you can achieve with SQL Complete',
        filePath: ''
      },
      {
        legacyId: 'UnifySQLstandards',
        href: "/sqlcomplete/getting-started/unify-sql-standards.html",
        title: "Unify SQL standards",
        subcategory: 'What you can achieve with SQL Complete',
        filePath: ''
      },
      {
        legacyId: 'Worksafewithsessionrestoration',
        href: "/sqlcomplete/getting-started/safe-work-restoration.html",
        title: "Work safe with session restoration",
        subcategory: 'What you can achieve with SQL Complete',
        filePath: ''
      },
      {
        legacyId: 'Operatewithdatainmultipleways',
        href: "/sqlcomplete/getting-started/operate-with-data.html",
        title: "Operate with data in multiple ways",
        subcategory: 'What you can achieve with SQL Complete',
        filePath: ''
      },
      {
        legacyId: 'Copyrightinformation',
        href: "/sqlcomplete/getting-started/copyright-information.html",
        title: "Copyright information",
        subcategory: 'Skip',
        filePath: ''
      },
      {
        legacyId: 'Requirements',
        href: "/sqlcomplete/getting-started/requirements.html",
        title: "Requirements",
        subcategory: 'Skip',
        filePath: ''
      },
      {
        legacyId: 'Installation',
        href: "/sqlcomplete/getting-started/installing.html",
        title: "Installation",
        subcategory: 'Skip',
        filePath: ''
      },
      {
        legacyId: 'Updates',
        href: "/sqlcomplete/getting-started/updating.html",
        title: "Updates",
        subcategory: 'Skip',
        filePath: ''
      },
      {
        leg
      }
    ]
  }
];
```

--------------------------------

### Azure DevOps Pipeline Step for dotConnect Installation

Source: https://docs.devart.com/dotconnect/zohobooks/Deployment.html

An example of a command-line task for an Azure DevOps pipeline to perform a full, silent installation of dotConnect for Zoho Books. This ensures the provider is available on the build server during CI/CD processes.

```yaml
- task: CmdLine@2
  inputs:
    script: '$(Build.SourcesDirectory)\dczohobooks.exe /TYPE=FULL /VERYSILENT'
```

--------------------------------

### SqlPackage Command-Line Syntax Example

Source: https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage

Demonstrates the basic command-line syntax for initiating SqlPackage actions. This includes specifying parameters, properties, and SQLCMD variables to control the utility's behavior.

```bash
SqlPackage {parameters} {properties} {SQLCMD variables}
```

--------------------------------

### Azure DevOps Pipeline Step for dotConnect Installation

Source: https://docs.devart.com/dotconnect/mysql/Deployment.html

This example demonstrates a command-line task for an Azure DevOps Pipeline to perform a full, silent installation of dotConnect for MySQL. This ensures the necessary assemblies and configurations are available on the build server during continuous integration. The command assumes the installer (dcmysql.exe) is located in the repository's root.

```yaml
- task: CmdLine@2
  inputs:
    script: '$(Build.SourcesDirectory)\dcmysql.exe /TYPE=FULL /VERYSILENT'
```

--------------------------------

### Run a Query in dbForge Studio

Source: https://blog.devart.com/install-windows-on-macos-with-parallels-and-run-dbforge-edge.html

This describes the process of running a query against a sample database (sakila) within dbForge Studio to verify the MySQL connection and setup. It involves navigating the Studio's interface to execute SQL commands.

```SQL
-- Example query to run against the sakila database
-- SELECT * FROM actor;
```

--------------------------------

### Extracting dbForge Studio for SQL Server to a Portable Version

Source: https://docs.devart.com/studio-for-sql-server/getting-started/installing.html

This command uses InnoExtract to extract the contents of the dbForge Studio installer into a specified directory, creating a portable version of the application. Ensure InnoExtract is in your PATH or provide its full path. The output directory can be specified using the -d flag.

```shell
D:\innoextract\innoextract.exe D:\Downloads\dbforgesql.exe
```

```shell
D:\innoextract\innoextract.exe -d D:\PortableApps\ D:\Downloads\dbforgesql.exe
```

--------------------------------

### Write Mathematical Expressions in Markdown

Source: https://guides.github.com/introduction/flow/

This example shows how to render mathematical expressions using LaTeX syntax within Markdown on GitHub. This is useful for scientific and academic documentation.

```latex
$$\sum_{i=1}^{n} i = \frac{n(n+1)}{2}$$
```

```latex
$$f(x) = a x^2 + b x + c$$
```

--------------------------------

### Install Winetricks on Ubuntu

Source: https://docs.devart.com/studio-for-mysql/getting-started/install-dbforge-studio-on-linux-using-wine.html

This snippet demonstrates how to download and install Winetricks, a helper script for Wine that simplifies the installation of various runtime libraries. It's crucial for ensuring applications with .NET dependencies function correctly.

```bash
wget https://raw.githubusercontent.com/Winetricks/winetricks/master/src/winetricks
chmod +x winetricks
sudo mv winetricks /usr/local/bin/
```

--------------------------------

### Create and Highlight Code Blocks with Syntax

Source: https://guides.github.com/introduction/flow/

This example shows how to create code blocks with specific language highlighting in Markdown. This makes code snippets easy to read and understand.

```markdown
```bash
git clone https://github.com/user/repo.git
cd repo
```
```

```markdown
```html
<!DOCTYPE html>
<html>
<body>
  <h1>Hello World</h1>
</body>
</html>
```
```

--------------------------------

### Navigation Data Structure

Source: https://docs.devart.com/studio-for-mysql/working-with-database-objects/finding-invalid-objects.html

A JavaScript array representing the navigation structure for the dbForge Studio for MySQL documentation. It categorizes content into sections like 'Get started' with subcategories for installation and requirements.

```javascript
rawNavData = [
  {
    legacyId: 'Getstarted',
    title: 'Get started',
    items: [
      {
        legacyId: 'Requirementsandcompatibility',
        href: "/studio-for-mysql/getting-started/requirements.html",
        title: "Requirements and compatibility",
        subcategory: 'Skip',
        filePath: 'Get started/Requirements and compatibility'
      },
      {
        legacyId: 'HowtoinstalldbForgeStudio',
        href: "/studio-for-mysql/getting-started/installing.html",
        title: "How to install dbForge Studio",
        subcategory: 'Installation',
        filePath: 'Get started/Installation/How to install dbForge Studio'
      },
      {
        legacyId: 'Installationfromthecommandline',
        href: "/studio-for-mysql/getting-started/installing-from-the-command-line.html",
        title: "Installation from the command line",
        subcategory: 'Installation',
        filePath: 'Get started/Installation/Installation from the command line'
      },
      {
        legacyId: 'Copyrightinformation',
        href: "/studio-for-mysql/getting-started/copyright.html",
        title: "Copyright information",
        subcategory: 'Skip',
        filePath: 'Get started/Copyright information'
      },
      {
        legacyId: 'HowtoinstalldbForgeStudioonLinuxmacOS',
        href: "/studio-for-mysql/getting-started/how-to-install-dbforge-studio-linux-mac.html",
        title: "How to install dbForge Studio on Linux & macOS",
        subcategory: 'How to run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/How to install dbForge Studio on Linux & macOS'
      },
      {
        legacyId: 'ScenariobasedinstallationofdbForgeStudioviaCrossOver',
        href: "/studio-for-mysql/getting-started/scenario-based-installation.html",
        title: "Scenario-based installation of dbForge Studio via CrossOver",
        subcategory: 'How to run dbForge Studio on Linux & macOS',
        filePath: 'Get started/How to run dbForge Studio on Linux & macOS/Using CrossOver/Scenario-based installation of dbForge Studio via CrossOver'
      },
      {
        legacyId: 'ManualinstallationofdbForgeStudioviaCrossOver',
        href: "/studio-for-mysql/getting-started/manual-installation.html",
        title: "Manual installation of dbForge Studio via CrossOver",
        subcategory: 'How to run dbForge Studio on Linux & ma'
      }
    ]
  }
];
```

--------------------------------

### Loading Custom Installation Settings

Source: https://docs.devart.com/studio-for-mysql/getting-started/installing-from-the-command-line.html

Performs an installation using previously saved custom settings from an .inf file. The installer executable is run with the /loadinf command, referencing the specific .inf file containing the desired configuration.

```bash
dbforgemysql.exe /loadinf="dbForge Studio for MySQL.inf"
```

--------------------------------

### Example Git Commands for GitHub Flow

Source: https://guides.github.com/introduction/flow/

This snippet provides example commands for performing common Git operations within the GitHub Flow. It includes creating branches, staging changes, committing them with descriptive messages, and pushing them to the remote repository. These commands are fundamental for managing code changes in a collaborative environment.

```shell
git checkout -b new-feature
git add .
git commit -m "feat: Implement new feature"
git push origin new-feature
```

--------------------------------

### sqlcmd (Go) Usage and Examples

Source: https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility

Demonstrates the command-line usage and common examples for the Go variant of sqlcmd, including operations like creating/querying SQL Server instances, managing configurations, and opening tools like Azure Data Studio.

```bash
# Install/Create, Query, Uninstall SQL Server
  sqlcmd create mssql --accept-eula --using https://aka.ms/AdventureWorksLT.bak
  sqlcmd open ads
  sqlcmd query "SELECT @@version"
  sqlcmd delete
# View configuration information and connection strings
  sqlcmd config view
  sqlcmd config cs

Available Commands:
  completion  Generate the autocompletion script for the specified shell
  config      Modify sqlconfig files using subcommands like "sqlcmd config use-context mssql"
  create      Install/Create SQL Server, Azure SQL, and Tools
  delete      Uninstall/Delete the current context
  help        Help about any command
  open        Open tools (e.g ADS) for current context
  query       Run a query against the current context
  start       Start current context
  stop        Stop current context

Flags:
  -?, --?                  help for backwards compatibility flags (-S, -U, -E etc.)
  -h, --help               help for sqlcmd
      --sqlconfig string   configuration file (default "/Users/<currentUser>/.sqlcmd/sqlconfig")
      --verbosity int      log level, error=0, warn=1, info=2, debug=3, trace=4 (default 2)
      --version            print version of sqlcmd

Use "sqlcmd [command] --help" for more information about a command.
```

--------------------------------

### Create Code Blocks in Markdown

Source: https://guides.github.com/introduction/flow/

Learn how to create and highlight code blocks in Markdown for clear presentation of code snippets within your GitHub content. This is essential for documentation and sharing code examples.

```markdown
```javascript
function greet(name) {
  console.log(`Hello, ${name}!`);
}

greet('World');
```
```

```markdown
```python
def add(a, b):
  return a + b

result = add(5, 3)
print(result)
```
```

--------------------------------

### Install Winetricks on Ubuntu

Source: https://blog.devart.com/how-to-run-dbforge-studio-for-mysql-on-ubuntu-with-wine.html

Installs Winetricks using wget and sets execute permissions. Ensure ~/.local/bin is in your PATH.

```bash
wget https://raw.githubusercontent.com/Winetricks/winetricks/master/src/winetricks -P ~/.local/bin/source ~/.profile
sudo chmod 700 ~/.local/bin/winetricks
```

--------------------------------

### SQL Server CHARINDEX() Example: With Starting Position

Source: https://blog.devart.com/charindex-function-in-sql-server.html

This example shows how to use CHARINDEX() with a specified starting position (4) to find the substring 'o' in 'Hello World', returning the position after the specified start.

```sql
SELECT CHARINDEX('o', 'Hello World', 4);
-- Result: 7
```

--------------------------------

### Example INIT.ORA Initialization Parameter File

Source: https://blog.devart.com/how-to-create-database-in-oracle.html

Provides a sample initialization parameter file (_init.ora_) for a new Oracle database. This file is used to configure database parameters and should be customized for specific needs.

```oracle
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you start by providing
# a starting point to customize your RDBMS installation for your site. 
# 
# NOTE: The values that are used in this file are only intended to be used
# as a starting point. You may want to adjust/tune those values to your
# specific hardware and needs. You may also consider using Database
# Configuration Assistant tool (DBCA) to create INIT file and to size your
# initial set of tablespaces based on the user input.
###############################################################################
 
# Change '<ORACLE_BASE>' to point to the oracle base (the one you specify at
# install time)
 
db_name='ORCL'
memory_target=1G
processes = 150
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300 
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='12.0.0'
```

--------------------------------

### Command Line: Minimal dotConnect for SQLite Installation

Source: https://docs.devart.com/dotconnect/sqlite/installation.html

This command executes the dotConnect for SQLite installer with specific parameters for a minimal installation. It installs only runtime assemblies and registers the provider in machine.config, while suppressing icons and showing no FAQ page.

```bash
dcsqlite.exe /TYPE=COMPACT /VERYSILENT /NOICONS
```