SQL Server Based PI Repository Migration Tool User Guide (4230193)

The migration tool helps users to migrate SQL PI data from Infobright to SQL Server-based PI repository.

It supports PU for Microsoft SQL Server, SSAS, and Oracle databases.

Pre-requisites

1. SQL Server-based PI repository has been created as described in KB 4227004
2. Operating System (where the tool will be installed)
   1. Windows x64
   2. Hardware requirements at least

How to use the migration tool

Install Migration Tool

1. Download the pi-ib-migrate-tool-2.1.zip attached to this KB article (see the download link at the bottom).
2. Unzip the file to your local computer. This file is named as follows:
   • 

Data Migration

PLEASE NOTE: Before using the migration tool, the new SQL Server database and schema must be created as per the KB 313191 (for SQL Server and Oracle database agents) and KB 315512 (for SSAS agents). 

For migration performance reasons, Quest R&D recommends running the migration tool on a system that is not the same system as where the Infobright PI repository is located. In this scenario, ports should be open between the source and target systems for the migration tool to connect (port 5029 by default for Infobright, port 1433 by default for SQL Server).

1. Launch Migration tool GUI like this:
   1. Open command prompt (Press Windows with R & type CMD).
   2. cd to the migration tool folder
   3. type start-gui.bat and press Enter

For permissions/path issues, please try running the batch file or command prompt as Administrator 

Select Instances

1. Fill in the source PostgreSQL database details including the servername, port (the default is usually 5029), username (the default is usually postgres), and password (the default is usually postgres)
2. Select the source schema and click the Connect button to verify the connection
3. Select PI Domain Database and fill in the destination servername, port (this is optional and will use the SQL Server browser capability on the server if the port is not filled in), the database username, and the password.
4. Select the target schema. This will be a schema created as part of the steps in KB 313191 (for SQL Server and Oracle database agents) and KB 315512 (for SSAS agents).
5. Click the Connect button to verify the connection.
6. Click Migrate Data

1. The left panel shows all instances from the source database. The green checkmark icon indicates that the same instance already exists in the target database.
   
   
2. Select the instances you need to migrate and click the '>' button
   
   
3. The right panel shows all selected instances that will be migrated, un-select instances by clicking the '<' or '<<' button.
   
   
4. After confirming the selected instances, click OK to begin migrating the PI data of the selected instances
   
   

Check the data migration results

Database Data migration Duration Reference:

Note:

• The migration tool only supports using a SQL Server Authentication Login.
• The SQL Server instance where the PI repository is installed should be SQL_Latin1_General_CP1_CI_AS
• The migration tool will migrate all tables data except 1-min tables.
• The migration tool can migrate up to 300 instances of data from Infobright to SQL Server-based PI repository at a time.
• The migration tool supports migrating PI data from different Infobright databases to the same MSSQL database.
• The migration tool will automatically check the data integrity verification first. If it identifies any table corruption, the migration tool will not begin the data migration process. Please contact Quest Software Support if you would like to proceed with data migration.
• Each Oracle RAC node is not counted as a monitored instance toward the total count of 300 agents per SQL Server PI repository instance.
• Duration estimates assume that the Infobright PI repository is on a server that has full CPU & Memory reservations, and that both the Infobright and SQL Server PI repositories are on the same local area network and domain.
• The migration tool cannot be used to migrate Infobright PI repository data to a different FMS environment or PI environment, it is only supported being used in the upgrade process from on the same FMS. 

Please refer to KB article 313191 for details on migrating SQL Server and Oracle database agents from an Infobright PI repository to a SQL Server based PI repository.

Please refer to KB article 315512 for details on migrating SQL Server Analysis Services (SSAS) agent from an Infobright PI repository to a SQL Server based PI repository.