|
| MS-Access Database Migration to SQL-Server, Oracle, DB2
Application Conversion to Java (JSP/J2EE), Crystal Reports.
Java Solution
For those who intend to implement the Access application front-end using Java
(JSP/J2EE), we can supply database and reporting components for Oracle, DB2,
and MS-SQL conversions including:
-
Data Definition Language script for the target DBMS that precisely
replicates the Access database design. Your DBA naming standards can be
applied to all generated objects, and table spaces specified.
Redundant indexes are ignored
and cascade update relationships are enforced.
-
Stored procedures required for Access Form conversions:
a) Insert procedures that return any auto-generated (Identity/Sequence)
values.
b) Update and Delete procedures that enforce optimistic concurrency.
c) Result-set retrieval procedures for Form Record Sources and any
Combo/List Boxes.
d) See
Oracle Example-1
-
Stored procedures converted from Access Query Definitions.
Oracle Example-2
-
Access Report conversion to Crystal (Business Objects) Report definition files
and associated stored procedures.
-
Access Report conversion to Microsoft SQL Server Report Data Layout files and
associated stored procedures.
Our approach lays an accurate and consistent DBMS foundation for building
Java client-side applications, with considerable time and cost savings over
other methods.
| |
