Service: re-engineering
Solution type: desktop application
Business area: financial and accounting
Period: 2004-2005
Key problems
The previous version of Economa Fixed Assets application was developed using FoxPro 6.0 language and the data layer was FoxPro database (XBase format). The FoxPro database didn’t meet the increasing modern demands of the Customer, such as the larger number of possible transactions and users, more security and operating in MetaFrame/ASP environment.
Solution
Arcadian developers decided that the data layer of the Fixed Assets application should be migrated to the SQL Server and the time-consuming parts of business logic should be moved to the server in order to improve application performance and make it a real client/server application. The main goal of the EFARE project was to convert the database storage of the existing application from FoxPro database (XBase) to SQL database (Microsoft SQL Server 2000) and to fix the performance problems by moving parts of business logic to the server. Besides, the project covered a number of enhancements to the applications functionality, such as: ASP and Citrix enhanced support; XML import/export to 3rd party systems; update to license generation/support; new SQL Server based backup/restore functionality; enhanced user management and security.
Development tools
- Microsoft Visual FoxPro 6.0 SP 5.
- Microsoft Visual FoxPro 8.0 SP 1
- MS Source Safe 6.0 SP5
- Test Track Pro v. 6.1
- InstallShield 10.5
- Citrix MetaFrame 1.8
Technologies used
- Microsoft Windows 2000/2003
- Microsoft SQL Server 2000 SP 3
- Terminal Server
Duration and scope
24 months / 15 000 person-hours = 1.7 person-years / 6 people