Closed
|
Case #
|
10017
|
|
Affiliated Job:
|
New Trier Township District 2031
|
|
Opened:
|
Unknown
|
|
Closed:
|
Unknown
|
Total Hit Count:
|
40846
|
|
Last Hit:
|
Wednesday, December 11, 2024 4:33:23 AM
|
Unique Hit Count:
|
9943
|
|
Last Unique Hit:
|
Tuesday, December 10, 2024 2:10:04 PM
|
Case Type(s):
|
Database, Server
|
|
Case Notes(s):
|
All cases are posted for review purposes only. Any implementations should be performed at your own risk.
|
|
|
Project:
|
Shortly after I started at New Trier, we lost our MIS Manager who had a variety of manually run synchronization routines in place to carry data between our many environments. I was tasked to review these integrations and either get them running or improve upon them.
I took his manually run routines, which were being performed through a Windows based Linux emulator which ran scripts that pulled data into temporary tables, adjusted the data and then carried that data into the destination system, and revised them into a single query with join statements that in the query "massaged" the data for the destination environments.
|
|
Action(s) Performed:
|
Total Action(s): 2
|
Action #
|
Recorded Date
|
Type
|
Hit(s)
|
User
|
Expand Details
|
10064
|
2/16/2010 2:58:46 PM
|
Database
|
3851
|
contact@danieljchu.com
|
We have internal and also outsourced hosted, almost all web products which More ...
|
10068
|
2/16/2010 2:35:29 PM
|
Database
|
3788
|
contact@danieljchu.com
|
Sample A.D. Query to Batch below, this assembles data from the eSchool stud More ...
|
|
|
Outcome:
|
The above scripts are now entirely automated in the form of DTS packages that run across our SQL 2000 & 2005 environment and also out to our vendors to supply any updated and year to year roll over activity. Through these scripts, a great number of previously manual activities, like a new student in the middle of a current year, can now be achieved entirely automated also allowing a single point of entry through the Student Records or Finance system.
|
|
|
|
|
|
|