Project description MIGRATIONS PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

UBS AG (Bankverein), Basel

UBS

MS Access, VBA, SQL, VB 6.0

UBS AG (Bankverein), Basel

PROJECT LINK: Not available
People in the PROJECT: Stefan Troehler
PROJECT Duration: 10 months
PROJECT Value: SFR. 00'000.00

Migrationen

Project portfolio
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT

The migration of 200 databases from Microsoft Access 2.0 to Microsoft Access 97. Frontend and backend were migrated. Logic that was implemented using VBA or macros was checked and adjusted if necessary. This applied to both the user interfaces and the reports.

  • Migration of approx. 200 Microsoft Access 2.0 applications to Microsoft Access 97.
  • No tools may be installed on the system for the migration of the 200 Microsoft Access applications.
  • Create an inventory of all existing Microsoft Access applications.
  • Identify applications and backups.
  • For backup copies and old data applications, the migration had to be carried out exclusively on Microsoft Access level.
  • With the current applications, the entire logic also had to be migrated.
  • OCX component (Microsoft Visual Basic 6.0) developed, which documents the entire application in a text file and searches the documentation for various keywords. Based on the search results, the migration could be carried out.
  • Test the migrated applications.