ERP / MRP Software        
       
 

 

 

 
  Question: How do I upgrade from a previous version?

Answer:  To install a new version of Catalyst, uninstall the prior version using either the Catalyst setup program or the Add and Remove Programs option in the Windows® Control Panel. After installing the new version on the client and server machines, you can import the data from your prior version to the back-end database of the new version using the Catalyst Upgrade Wizard as described below.

The Refresh Data option in the Catalyst menu under File > Database Management > Refresh Data launches the Catalyst Upgrade Wizard. The wizard transfers records from one Catalyst back-end database to another and can be used to upgrade from a prior version of Catalyst Manufacturing® beginning with version 4.49. The back-end database which you are importing from is referred to as the source database. The currently selected company data file is the default target database. The target database should be the empty database that is supplied with each new release. To change the target database, exit the wizard and choose a new back-end database using the File > Select Company option.

Before running the wizard, all users must be logged off both the target and source back-end databases. It is highly recommended that you make a backup of both databases before proceeding. In addition, the data transfer will run much faster with both databases on the same local machine.

The steps of the Catalyst Upgrade Wizard are outlined below.

1.      The first step confirms the current back-end database. The current back-end is the target database into which records from the source back-end database will be imported. The target path cannot be edited directly. To change the current back-end database, exit the wizard and choose the Select Company option under the File menu. Before proceeding, indicate whether the source data that you will be importing resides in a Microsoft Access® or SQL Server® database

2.      In the second step, you are asked to specify the source database from which data will be imported. If you selected a Microsoft Access® source, use the Browse button to enter the file name and path of the mdb file. If you selected a SQL Server® source, select the server and database name of the SQL Server database. Verify the source database version and edit as required.

3.      In the third step, you have the option to let the wizard perform the necessary table changes on your source back-end database to match the target back-end. This step will be skipped if you are transferring data between two databases of the same version. The table structure of the source and target databases must be identical before data can be transferred between them. Any custom changes made to the source database will need to be replicated in the target database manually.

4.      The final step in the upgrade process is the transfer of data from the source to the target back-end database. All records in the target database will be replaced by records in the source database. Any autonumber and key field values from the source database will be preserved during import.  

When the import process completes, you will be able to review an Error Log Report that summarizes any import errors encountered. If errors were reported during the upgrade process, perform the changes suggested on the Error Log Report manually and rerun the Upgrade Wizard. It is recommended that you verify that the data in key tables has refreshed correctly before resuming normal operation.

 

 
Back to FAQ
 
   
Copyright © 2002-2008 Manufacturing Advisors, LLC dba Catalyst Manufacturing.
All rights reserved.

Catalyst Manufacturing® is a registered trademark and Catalyst MFG™ is a trademark of Manufacturing Advisors, LLC. "Accelerate the way you do business" is a service mark of Manufacturing Advisors, LLC.

To navigate this web site, please use the navigation bar or refer to the site map.

Questions or problems regarding this web site should be directed to admin@mfgcatalyst.com.
Last modified: 02/05/08.