Migrating Xpress Insight
You can migrate an
Xpress Insight repository to a new machine.
Use any of the following methods.
Complete one of the following:
- (Preferred Option) Use the
insightcmd command line tool to export the entire repository to a file. The
insightcmd tool can then be used from a new installation of
Xpress Insight to import the data. You need the
SYS_IMPORTEXPORT authority to perform this action. The
Xpress Insight Server must be running to execute the import and export operations.
Full details of the insightcmd command syntax are available in http://www.fico.com/fico-xpress-optimization/docs/latest/insight_admin/index.html.
- Use the backup and restore database method as described in
http://www.fico.com/fico-xpress-optimization/docs/latest/insight_admin/index.html.
- You need the database account username and password. The Xpress Insight Server must not be running during the backup and restore operations.
- Manually copy the <installdir>/insight/db/pgsql/data folder to the new location. The PostgreSQL database service must be stopped prior to performing this operation to avoid pending data updates being lost or possible data corruption.
The Export Repository, being the simplest method to execute, is the preferred method to migrate a repository. However for very large repositories, the time required to export and import the data may be considerable. It is recommended that you perform a test export of the repository to identify the approximate time required prior to any scheduled migration window. If the duration of the export is considerable, then one of the other two methods can be used to perform a much quicker data migration.