aPriori Professional Installation Guide
1 Planning Your Installation
Releases and Installation Types
Upgrade paths
Acquiring the Installation Files
To download and extract installation files
Summary of Required Procedures
Understanding release versions
Interoperability
Understanding installation types
2 First-Time Installations
Planning a First-Time Installation
Deployment Options
Client Deployment Options
Database Deployment Options
Managing Deployments
Recommended Standard Deployment
Advanced deployments
Installing Prerequisite Software
Prerequisite Database Software
Clients
Installing a CAD Application
Installing and Configuring a Database
MySQL Installation and Configuration
Installing MySQL Server on Windows
To begin MySQL server installation on Windows (MySQL Win Part 1)
MySQL Server Configuration screen (MySQL Win Part 2)
MySQL Workbench (MySQL Win Part 3)
Import standarddata.sql (MySQL Win Part4)
Create a user and assign privileges (MySQL Win Part 5)
FOR ENTERPRISE PLATFORM ONLY - Edit the startup file (MySQL Win Part 6)
Restart the MySQL service (MySQL Win Part 7)
Anti-virus Software Exceptions for MySQL (MySQL Win Part 8)
Installing MySQL on Linux
MySQL Client Components (MySQL Linux Part 1)
MySQL Server Components (MySQL Linux Part 2)
Securing MySQL on Linux (MySQL Linux Part 3)
MySQL Options File in Linux (MySQL Linux Part 4)
Creating the aPriori database and users in Linux (MySQL Linux Part 5)
Oracle Installation and Configuration
Installing Oracle
To install and configure Oracle
To import the Oracle data files
Additional Oracle information
SQL Server Installation and Configuration
Installing SQL Server
To install and configure SQL Server
To create a SQL Server database instance
aPriori Client Installation Adjustments
A Note About Deleting SQL Server Databases
Installing the aPriori Professional Client
Before You Begin
Install by Using the aPriori Professional Setup Wizard
Welcome screen
License Agreement
Select Destination Directory
Select Components
Document Cache Configuration
Database Schema Configuration
Schema Verification
Oracle ONLY – SID vs. Service Name
SQL Server ONLY – Authentication Style
Memory Configuration
Creo and Pro/ENGINEER Configuration
aPriori Properties Configuration
Bulk Costing Plug-In Properties Configuration
About to Install
Installation in Progress
Installation Done
Faster subsequent installations
Uninstalling
Uninstaller Welcome screen
Uninstall in Progress
Uninstall Done
More on File Permissions
Silent Client Install
Configuring and Starting aPriori
Load the License File
To load the license:
Add aPriori User Accounts
Starting the CAD-Independent Client
Starting the Direct Integration Client
To expand to aPriori Desktop
To manually disconnect from the CAD system:
To manually connect to the CAD system:
Configuring the Test and Training Databases
Installing the CAD Plugin
Pre-requisites
Installation
Editing the Configuration
Silent Installation
To install silently
To uninstall silently
Installation Checklist
Database
Client
3 Update Installations
Back Up and Update the aPriori Professional Client
Overview of Database Upgrades
Types of upgrades
Which method should I choose?
Upgrading in a Test Environment
MySQL considerations
Definition of Terms
General prerequisites
Update – Test Environment
Prepare for the test update
Update Deployment Links
Continue with the update process
Perform the database upgrade procedure
Run the upgrade script
Run the Compatibility Script
Install the VPE baseline update
Acquire and install Regional Data Libraries
Extensively test the update
Update – Production Environment
Prepare for the production upgrade
Perform the update, adjusting as necessary
A. Performing a Full Database Migration
Prerequisites for migration
Overview of Steps
Data Export
Set up the Source Version
Export data out of the Source Version
Data Import
Setup the target version
Import the data into the target version
Testing
Test the VPEs
Moving to production
Plan and Schedule Production Changes
Upgrade the Client Software
B. Migration by Support
Overview of steps
Exporting, importing, and testing
Moving from Testing to Production
C. Troubleshooting aPriori as a Creo Toolkit Application
No Error Message
aP Wrapper Failure
D. SQL Server Export Tools
Export using SQL Server Management Studio (SSMS)
Exporting using aPriori’s PowerShell script
aPriori Professional Installation Guide
Exporting using aPriori’s PowerShell script
aPPro_IG_title_page
aPPro_Install_Welcome
aPPro_Install_License
aPPro_Install_Select_Dest
aPPro_Install_Select_Comps
aPPro_Install_Doc_Cache_Config
aPPro_Install_Op_DB_Config
aPPro_Install_Memory_Config
aPPro_Install_Creo_ProE_Config
aPPro_Install_aP_Properties_Config
aPPro_Install_Bulk_Cost_Properties_Config
aPPro_Install_About_to_Install
aPPro_Install_Progress
aPPro_Install_Done
aPPro_Uninstall_Welcome
aPPro_Uninstall_Progress
aPPro_Uninstall_Done