Documentation for ProTrack Warehouse 7.5.
The following migration process is to be completed by a database admin (DBA).
The Move_LocationData_sp makes it easy to move XYZ data from one database to another while maintaining the integrity of the data. This functionality allows the user to configure the XYZs for new facilities or make changes to the configuration of existing facilities on a test environment separate from the production environment. This practice provides the security that any unintentional changes will not have a negative effect on the production standard calculations. Additionally, the XYZ data transfer ensures that ProTrack Warehouse does not process incorrectly any of the production data resulting from importing XYZ data while simultaneously importing WMS data.
There are two separate stored procedures that may be run to transfer data from a Test Environment to a Production system. The first (Move_LocationData_sp) is used to move the actual XYZ component data. The second only moves the two caches. Depending on the maintenance scenario, it may only be necessary to move the cache.
The Move_LocationData_sp copies all XYZ component data from one database to another. The stored procedure moves data from the following tables:
The Move_Cache_sp is used to move just the cache tables from one database to another:
Info
All modifications are done in one direction reading from a database that is designated as "Source" and updating the database designated "Destination". Any errors while executing this request will result in a full rollback of the data.
Fig.198 System Configuration
Fig.198 System Configuration - Disable System