Transcript Slide 1

Fifth in a series
Nightly Procedures
November 2010
Nightly Procedures
 Outcome: to efficiently access data
 No impact to server speed
 No risk to live data
 Three nightly procedures
 AEAs and Bureaus (IMS)
 SQL Replication Server (IFSP and IEP)
 Nightly Exports (IFSP and IEP )
AEAs and Bureaus: Step 1
IMS SQL
IMS
Text Files
AEAs and Bureaus: Step 2
IMS
Text Files
IMS
FoxPro
Format
AEAs and Bureaus: Step 3
AEA 12
AEA 7
AEA 8
AEA 1
AEA 10
IMS
AEA 9
Bureaus
AEA 15
AEA 11
AEA 13
Why?
 Allows AEAs to use FoxPro reports
for SQL database
 Reports already written in FoxPro
 Database changed for web system
 Process created to “convert” data from
SQL back to FoxPro
SQL Replication
Live IFSP and IEP SQL
Copy of IFSP and IEP SQL
Why?
 Prepare for the retirement of FoxPro
reports
 Query data without accessing live site
and IFSP
IEP Nightly Exports
Live IEP SQL and Live IFSP SQL
AEA 15
AEA 9
AEA 1
AEA 8
AEA 11
AEA 12
AEA 7
AEA 13
AEA 10
Why?
 Eliminate the data gap
 Obtain data as needed
Fifth in a series
Nightly Procedures
November 2010