Security Trade Management System Migration from MS Access to MS SQL 2008

Brief Description

Security and Trade Management System provides integrated modules for bond, trade or security trading process. The system was initially using a Microsoft Access as backend. However, as the company was growing and the number of locations and users of the system were increasing, it was required to migrate the existing application from MS Access to MS SQL to improve data security, concurrency, shared data dependency, accessibility and scalability.

Elegant MicroWeb successfully migrated the system, including past data from MS Access to MS SQL server. The following approach was followed to migrate the system to MS SQL.

Step I: Planning and Designing

  • Selecting the most appropriate RDBMS and its version
  • Identifying differences in SQL syntax, data migration challenges, data type conversion issues, change impact on application ( entry and reports ), architectural issues
  • Deriving migration and development plan

Step II: Implementation

  • Development (application and RDBMS)
  • Migration
  • Testing
  • Documentation
  • Rollout beta version
  • Rollout production version

Tools and Platform

  • Front end: VB.NET thick client
  • Back end: MS SQL 2008
  • Reporting / Third Party Tool
  • Crystal XI V2
  • 10tac Grid
  • Bloomberg APIs
  • Redemption
  • Scrolling Text
  • Application: Security Trade & Management System
Security Trade Management System

Technical Competency

  • .NET Programming
  • SQL Scripts
  • Migrating an application and data to another RDBMS
  • Design & Development

Programming Technologies

Java Development .NET Application Development PHP Programming

Customer Testimonials

“The Elegant MicroWeb redesign of our site has really helped our sales. Immediately after implementing the custom template they designed for our Volusion™ storefront we noticed an increase in our online sales. We cannot thank them enough for their prompt, professional and courteous service! Hands down, Elegant MicroWeb provides a great service at an unbeatable value.”

– Leading supplier of Boat Maintenance Equipments & Accessories

“ElegantJ Business Intelligence played a pivotal role helping my team tap into the huge amount of timekeeping data our firm had assiduously collected over several years, but which we had extracted very little value from. We realised that with ElegantJ BI we could gain an insight into our business performance and trends which we were then able to present to Management in a digestible form. As a direct result of our analysis using ElegantJ BI we were able to ensure that scarce resources were ring-fenced for critical operations whilst also freeing up resource from other areas to improve productivity and allocate costs more accurately across our operations. ElegantJ BI proved an excellent partner, listening to and taking our feedback on-board, then delivering changes and improvements to the product.”

– World leader in financial news & data feeds, UK

“We were looking for 100% browser based, feature rich, simple to use BI tool that has shorter learning curve and implementation cycle. We found that ElegantJ BI is the tool meeting our requirements, we are glad to have ElegantJ BI implemented in our organization with shorter implementation cycle, ease of use and faster ROI.”

– Leading Infrastructure Development Company, Saudi Arabia

“You can tell when a strategic supplier truly understands your business and your needs: he takes your brief, your product requirements and he makes that specification much better than you imagined. Elegant MicroWeb has done that for us since day one – five years ago! Without our strategic alliance with Elegant MicroWeb, I doubt if we would have become #1 supplier of eDemocracy and eConsultation solutions. If your need is for service, imagination, creativity and value, use Elegant!”

– Leading supplier of eDemocracy and eConsultation solutions

“The staff at Elegant MicroWeb was very professional from the beginning and the entire experience of working with the project manager and other staff members at Elegant MicroWeb was an absolute delight. The response time is phenomenal. The project went very smoothly and they truly exceeded my expectations. The follow up responsiveness is just as good and we still receive the same support we did on day one of the project. We will definitely continue this relationship with the folks at Elegant MicroWeb and look forward to executing more exciting IT projects with them.”

– Pioneer in providing online management of clinical tests