Manual installation of Querona and Apache Spark metabases on SQL Server

Note

WARNING: Please deploy database manually only when automatic installation does not meet your specific requirements.

To manually deploy or update Querona and Apache Spark metabases the following options are available:

Note

Documentation assumes you use DacFramework to manually deploy databases.

Ensure Microsoft DacFramework is available on the installation machine

The installation package of DacFramework 13.0 or later can be downloaded from Microsoft Download Site (choose “Download Data-Tier Application Framework (DacFx)”. DacFramework versions earlier than 13.0 are not supported.

Note

DacFramework version 14.0 requires .Net 4.6 or later. DacFramework installer does not warn about this dependency during install, therefore please ensure that installation machine has .Net 4.6 or later installed.

To install DacFramework please run DacFramework.msi file downloaded from Microsoft Download Site, and follow the on screen instructions. Installation is very straight forward and we recommend to accept the defaults. Installed DacFramework files can be found under C:Program FilesMicrosoft SQL Serverversion-numberDACbin, where version-number is the version number of installed DacFramework.

Deploy metabases using DacFramework

To install Querona and Apache Spark metabases to a chosen SQL Server instance follow the following procedure. Examples assume that you deploy to SQL Server on current computer and default SQL Server instance (localhost). Please change “localhost” in the scripts below to a proper name of your target database server.

  1. Open command prompt and change current folder to Querona installer folder.

  2. Run the following command to install Querona metabase (edit if necessary):

    “C:Program FilesMicrosoft SQL Server140DACbinSqlPackage.exe” /Action:Publish /SourceFile:querona.dacpac /TargetServerName:localhost /TargetDatabaseName:Querona

  3. Run the following command to install Apache Spark metabase (edit if necessary):

Note

WARNING: Please be extra careful when manually updating existing Apache Spark metabase and ensure that you have the latest backup. If you omit parameter DropObjectsNotInSource=false, existing database objects will be dropped along with data. In such case the only recovery option is to restore metabase from backup.

“C:Program FilesMicrosoft SQL Server140DACbinSqlPackage.exe” /Action:Publish /SourceFile:SparkMetastore.dacpac /TargetServerName:localhost /TargetDatabaseName:SparkMetastore /p:DropObjectsNotInSource=false

Apache Spark metabase schema is managed by Spark. Installer does not create or alter tables or views inside Spark metabase. Initially deployed SparkMetastore database will be empty and ready for database objects configuration by Apache Spark itself. Apache Spark will initialize its metastore and will check database schema compatibility on each start-up. If necessary it will update schema to required version.

Please continue with Querona server installation procedure.