Service: re-engineering
Solution type: desktop application
Business area: financials & accounting
Period: 2004-2005
Key problems
The previous version of Fixed Assets Management application was developed using FoxPro 6.0 language; the data layer was FoxPro database (XBase format). The FoxPro database didn’t meet the increasing modern demands of the Client, 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 MS 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 (MS 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
- MS Visual FoxPro 6.0 SP 5.
- MS Visual FoxPro 8.0 SP 1
- MS SourceSafe 6.0 SP5
- TestTrack Pro v. 6.1
- InstallShield 10.5
- Citrix MetaFrame 1.8
Technologies used
- MS Windows 2000/2003
- MS SQL Server 2000 SP 3
- Terminal Server
Duration and scope
24 months / 91 person-months