Project description MIGRATIONS PROJECTS

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

Database compiler migration from Access to Microsoft SQL Server - SQL, T-SQL

UBS

Microsoft SQL Server – SQL, T–SQL

UBS AG, Zürich

PROJECT LINK: Not available
People in the PROJECT: Stefan Troehler
PROJECT Duration: 36 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

Creation of a prototype of a database compiler that is able to convert process-oriented flow structures and flow diagrams into stored functions. The application is used to enter the signatures of the employees with regard to the legal templates in the commercial register. A rule management of over 2000 active rules is taken into account when registering employees. Not only the database compiler is ordered, but also various auxiliary programs, which are necessary for the automated process from the mail to the published signature on the Internet. The application is implemented using Microsoft SQL Server, SQL, T SQ, .NET and C #.

Administration of physical signatures of authorized signatories taking into account internal and legal requirements.

  • Technology: Multi Layer Technology.
  • Microsoft SQL Server database.
  • Logic implemented using T-SQL (graphic generation of stored procedures - worldwide patents).
  • Integrated security layer implemented using Microsoft SQL Server, T-SQL and VB.
  • A compiler will be developed based on the Microsoft Access prototype.
  • Recursive generation of the Transact SQL Stored Procedures
  • At a later date, the application will be migrated from Microsoft VB to Java and from Microsoft SQL Server to Oracle
  • Automated entry of signatures in the public registers
  • Responsible for data modeling, database development (SQL Server) and implementation of the logic in Transact SQL.
  • Image processing tools in the .NET area (C #, EPF, WCF etc)
  • Interface between compiler and database