Data Migration City of Champaign

1
Data Migration City of Champaign

• From MS Access to MS SQL Server
• Group 3 Matthew Loar
• Matthew Tjarks
• Shan-I Hsieh
• Seth Wing

2
Legal Department

• Uses MS Access handling and collecting fines.
• Database is populated by ARMS.
• Update and build reports

3
Finance Department

• Similar to Legal Department except much less
  data.
• Collect various payment owed to the City.
• Once unpaid payment become fines, turn to Legal
  Department.

4
Tasks

• Problems 1.Two Departments use two separated
  databases, which share a numbers of
  characteristics. Consolidation is needed.
• 2. They use MS Access! Data migration
  is needed.

5
Access vs. SQL Server

• Access uses MS Jet Database Engine, a file/server
  data manager. SQL Server is a client/server
  database engine.
• Data integrity Jet has no transaction logging.
• Scalability SQL - unlimited number of concurrent
  users, terabyte level of data. Jet Maximum of
  255 users, 2GB of data.

6
Solutions

• Create a new database on MS SQL 2000 Server
• Access to the database will be a web-based front
  end accomplished with PHP scripting language.
• Use Adobe Acrobat to generate forms for legal
  document
• Set permission level for different users.

7
What can users do?

• Legal Department
• Import data from ARMS
• Query and generate reports
• Update information
• Finance Department
• View particular data through browser

8
What can be accomplished

• Database
• - Scalability
• - Performance
• - Consistency
• - Data Integrity
• Eliminate human communication between the two
  department. Use less papers!

9
Things to keep in mind

• Ensuring that front-end is intuitive and easy to
  use. Minimize the learning curve.
• Dealing with sensitive information.
• No delay during the migration.

10
Comments, Suggestions, Questions?

• Anyone?