What are the basic steps in an Escort SQL migration?
After installing the Escort SQL software, the application object programs are prepared through a simple, one-time process requiring a second or two per program. When the object files are ready, they can be tested for pass through mode (no SQL database) and placed in production. This should have no effect on the overall operation. The database is migrated, usually a few files at a time. This involves a SQL table design process, creating the production SQL tables, loading the Enscribe data into the SQL tables, and then restarting the application processes with the SQL tables replacing the Enscribe files. Once the data migration is complete, you have many options as described below. Return to Top Question: How long will it take to convert my applications and data to NonStop SQL. Answer: Installing Escort SQL and converting the application programs are truly a less-than-one-day task. The bulk of the time required for migration is in the design of the SQL tables, loading the data from Enscr
