781-285-4236 T.
781-934-8996 F.

Journaling image

Escort Journaling in the Carr Scott Compendium of Success

Escort Journaling FAQ's
News & Info
Price Quote
Contact Us
Request Trial Software

Escort Journaling Breaking News
“Effective 24 December 2013 - comForte has acquired the Escort suite of products from Carr Scott Software. Details of the transaction can be found here, and more information about the products can be found here

While Carr Scott Software remains actively involved with the support of these products, primary sales/marketing has shifted to comForte. For further information, please Contact comForte here

Escort Journaling allows databases to be loaded on-line, while the "source" data files are being accessed and updated. This is especially important in cases where customers are upgrading from Enscribe to NonStop SQL, but have little or no downtime window for doing the actual data migration. On-line database loading using Escort Journaling eliminates costly application downtime, improving customer application availability, yet provides an efficient method for replacing database files on-line.

Escort Journaling captures changes that occur during the on-line background database load, and then applies these changes to the new file, all on-line during normal application processing!

How Does Escort Journaling Work?
This diagram illustrates how a database file, (currently the active database) can be used as a source to load a new file and how Escort Journaling captures the changes and then applies these to the destination new data file - all as an on-line operation.

Step 1 - Application Live - The current application is accessing the "source" file as normal.

Step 2 - Begin Journaling - Within Escort, start Journaling capture of changes to "source" file.

Step 3 - Start DB Load - Begin the background loading process. This loads the data from the "source" to the "destination" new file, in the background, while activity continues to occur by the applications to the "source" data, as Escort Journaling captures any changes in the Journal file.

Step 4 - Apply Journal - Once the background load of the data is complete, begin applying the Journalled database changes from the Journal file to the "destination" file. Note: Journaling is applying changes from the Journal file to the "destination" while continuing to capture new Journal changes, as the applications are still using the "source" file at this point in the process.

Step 4a - When the bulk of the journalled changes have been applied to the "destination" file and it is convenient to perform that actual switch over, the application programs should be briefly suspended to allow the final Journaling entries to be captured and applied to the "destination".

Step 5 - Redirect Applications - When the Journal file is empty (i.e., all changes to the "source" have been applied to the "destination" by Escort Journaling), the application should be changed to point to the new file (i.e., was "destination" and will now become the live database), and the application programs should be allowed to resume processing against the new database.

The process should allow most applications to have minimal downtime or outage for the cut-over (i.e., a very few minutes).

Click here to contact us
Click here to request a software trial
Click here for a price quote

Home | Products | Escort SQL | AutoSYNC | AutoTMF  | SDR | Ranger | Journaling | Evaluation Program | News & Updates | Training | Support | Distributors | About Us | Links | Contact Us
Copyright © 1996-2012, Carr Scott Software Incorporated. Website designed by DLFwebgroup