Page History

...

1. Disable the scheduled task operations in both the Source and Destination environments.
   1. Log in to ProTrack Warehouse.
   2. Click System under the Configuration menu.

   3. Click on the Scheduled Task sub-tab.
      Image Removed
      Image Added
      ^{Fig.1 System Configuration}

       

   4. Select “N” for ALL of the drop down boxes.

   5. Select all of the check boxes.
      Image Removed
      Image Added
      ^{Fig.2 System Configuration - Disable System}

       

   6. Click  to save the changes.
2. Ensure that all processing in both environments is complete.
   1. Scheduled Request Records.
      1. Click on the Monitor tab.
      2. Click on the Scheduled Request tab.
      3. Click .
      4. Search for all records where the status is INP.
      5. If there are any records in INP wait for these records to leave INP status. All WMS processing is complete when there are no records in the Scheduled Request that are in INP status.
   2. Batch Process Records.
      1. XYZ data is imported based on a batch process that runs based on a configurable time interval.
      2. Check that there are no files in the import directories on the application server for the following import types:
         1. Facility
         2. Floor
         3. Aisles Path
         4. Segment
         5. Location
         6. Travel Path
   3. During the XYZ transfer process you will also want to ensure that nodes are not generated from the facility layout screen in either environment. This process cannot be disabled and will have to be independently monitored by the users.
3. Access SQL for the database that is going to be updated. This database will be referred to as the Destination database. The database that contains the updated XYZ information will be referred to as the Source database.
4. Ensure that the following stored procedures have been installed in the destination database:
   1. Move_Aisle_Path_Node_sp.sql
   2. Move_Aisle_Path_sp.sql
   3. Move_Cache_sp.sql
   4. Move_Facility_sp.sql
   5. Move_Floor_sp.sql
   6. Move_Level_sp.sql
   7. Move_Location_sp.sql
   8. Move_LocationData_sp.sql
   9. Move_Node_sp.sql
   10. Move_Segment_sp.sql
   11. Move_Travel_Path_Node_sp.sql
   12. Move_Travel_Path_sp.sql
   13. LinkedServerConnection_sp.sql
5. Backup both the Source and Destination databases.
6. It is assumed that when Move_LocationData_sp is being run, Move_Cache_sp will also be run afterward.
7. If running the Move_Locationdata_sp:

   1. ONLY IF RUNNING MOVE_LOCATIONDATA_SP: Delete all XYZ data in the destination database by opening a new query (pointed at the destination database) and run the following statements, one-by-one from top to bottom:

      Code Block
      Delete from level Delete from location Delete from segment Delete from aisle_path_node Delete from travel_path_node Delete from node Delete from aisle_path Delete from travel_path Delete from TravelPathHistoryDetails Delete from TravelPathHistory Delete from NodeCache

   2. Open a new Query pointed at the destination database.

   3. Run the following query:

      Code Block
      exec dbo.Move_LocationData_sp @SourceDB = 'Insert Source DB Name Here', @DestDB = 'Insert Destination DB Name Here', @SourceServer = 'Insert Source Server Name or IP address Here', @DestServer = 'Insert Destination Server Name or IP address Here', @LinkedUserName = 'protrack', @LinkedUserPwd = 'protrack', @Debug = 0

   4. Wait for the query to result as complete.
   5. Open a new Query pointed at the destination database.

   6. Run the following query:

      Code Block
      exec dbo.Move_Cache_sp 'Insert Source DB Name Here', 'Insert Destination DB Name Here', 'Insert Source Server Name or IP address Here', 'Insert Destination Server Name or IP address Here', 'INSERT'

8. If only running the Move_Cache_sp:

   1. Delete all cache data in the destination database by opening a new query (pointed at the destination database) and run the following statements, one-by-one from top to bottom:

      Code Block
      Delete from TravelPathHistoryDetails Delete from TravelPathHistory Delete from NodeCache

   2. Open a new Query pointed at the destination database.

   3. Run the following query:

      Code Block
      EXEC dbo.Move_Cache_sp 'Insert Source DB Name Here', 'Insert Destination DB Name Here', 'Insert Source Server Name or IP address Here', 'Insert Destination Server Name or IP address Here', 'INSERT'

9. Validate that all known differences between the two databases have been synchronized and that all of the effected tables have the same number of records.
   1. Run and additional comparisons as seen fit until confident that the data was transferred successfully
   2. If there are any discrepancies restore the databases from their backups and double check that steps 1 and 2 had been completed successfully.
   3. If problems still exist contact TZA.
10. Enable the scheduled task operations in both the Source and Destination environments.
    1. Log in to ProTrack Warehouse.
    2. Click the System tab under the Configuration menu.
    3. Click on the Scheduled Task sub-tab.
    4. Select “Y” for all of the drop down boxes.
    5. Select all of the check boxes.
    6. Click  to save the changes.