August 8, 2017 By: Tarun Ahuja
Application migration and re-engineering is a process performed by an IT expert for the sole purpose of migrating an organization’s existing environment to a newer, enhanced and more secure environment which may or may not be on the same platform as its predecessor.
This is why a well-designed, carefully crafted approach is necessary when considering application migration and re-engineering.
The transfer occurs after considering the pros and cons and carving a logical methodology and process. Some companies implement a 12-step program which follows as under:
- Database conversion
- Application conversion
- Script conversion
- Integration with third-party applications
- Data migration
- Functional testing
- Performance tuning
- Integration and deployment
- Training and knowledge transfer
- Documentation and version control
- Post production support
Since a typical migration project is complex in nature, it goes through several stages. Some of them are listed as under:
Migration Readiness Stage
- Analyse the data environment, calculate risks and construct a business scenario.
- Identify SMEs and stakeholders.
- Plan for the destination server’s hardware and software capacity.
- Define engagement model.
- Assess the existing database and design SQL Server database to provide the same functionality.
- Construct a customized roadmap for migration based on the outlined business objectives.
- Migrate database and verify database schema and validate whether the data migration was successful.
Extract, Transform, and Load Stage
- Design and develop ETL packages for simultaneous data load from a previous database onto the new SQL server database.
- Test data load performance.
- Setup and validate security, monitoring and replication functions.
- Validate data in SQL server database for technical accuracy and functionality.
Application Remediation Stage
- Performance integration testing using those applications that were consuming data in the previous database and making necessary modifications to ensure they work in the new SQL Server.
- Performance user acceptance testing.
- Training and knowledge transfer.
- Implement product environment.
- Post production support.
Beyond this, is the phase of testing and validation strategy, and deciding migration options by a team of experts from JK Tech.