Installing PartitionDB

Welcome to the PartitionDB Installation Guide! We hope you’re excited to start a new journey in DB scale-out.

In this section we’ll walk you step by step through the PartitionDB installation process via one of two ways:

  1. Management (recommended)
  2. BAK file (manual)

Dry run before you start

Before you start the installation, you may want to get a quick pick at PartitionDB logic and concepts. The below script will go over your database, analyse it and will recommend the following:

  • Ten most suitable columns to serve as partition column.
  • List of the ten largest tables, from which it is recommended to select the partition column in case you could not find the a proper one in the first list.

Running this script will not change anything in your database. It will give you some idea what PartitionDB is, and what to consider after installing it. Running this script is optional; You can skip it and start the installation.

Make sure to set your database name in the first line of the script before you run it.

Management Installation

This kind of installation allows you access our GUI, where you can manage your PartitionDB configuration. We recommend this as a guiding tool for your configuration process.

  1. Start by download  PartitionDB System.
  2. Open the downloaded file to trigger the Installation Wizard, and to install PartitionDB.
  3. Open MSSQL. You will see a PartitionDB drop-down menu at the top of the application, along with our GUI:

Installation Guide Screen Shot 1

tsql Bak file Installation

You may instead choose to work without our GUI, if mandated by your company’s security guidelines.

*Please note that all the functionality that exists in the tsql Bak file is also available via the Management Installation, with the addition of the GUI.

    1. Start by downloading PdbLogic.bak file.
    2. Open MSSQL.
    3. Right-click the Databases and choose Restore Databases.
    4. A popup will appear as shown in the image below. Click OK.

Installation Guide Screen Shot 2

 

An alternative way of restoring the Bak file is by running the below script:

Make sure you write the path here:

declare @command nvarchar(max) = 'restore database [PdbLogic] from disk = '' YOUR PATH '' with replace'