Solutions / DB Migration / Migration Methodology
Migration Methodology
Our Migration Methodology
There is no automated tool available in the market for migrating from the proprietary databases to open source databases completely. All the available tools have flexibility to perform the task partially having mandatory human intervention on provisioning work around along with application level changes.
Migration is very complex one time task and converting the application from one RDBMS to another is challenge that solely depends upon the features that used in database back end code. These need a work around at database level and sometime for unsupported features on PostgreSQL need to be accommodate at application to obtain the same functionality.
Shreeyansh has in depth migration capabilities for migrating of mission critical propitiatory databases to PostgreSQL. Shreeyansh removes the customer worries on getting the migration resource expertise by owning complete responsibilities of a migration life cycle till reach it into PostgreSQL DBA Support..
-
Phase 0
Migration Assessment -
Phase 1
Project Migration -
Phase 2
Live Implementation -
Phase 3
PostgreSQL DBA Support
Not all the databases are good candidate for the migration and there is a need for prior assessment of the source database whether it is a good candidate for the to get into the migration efforts. This is a paid service and will review the following on source (Test) Environment to capture the actual migration cost/time involved for the successful database migration.
- Customer provide list of users/databases/schemas to migrate on Test Env with out data.
- Remote access to customer Environment via VPN with READ access to database.
- Scripts execution permission to read from DB and No writes performed on the DB during the service.
- In depth review of database features used.
- In depth review of logical objects that participate for migration task.
- Business logic code review.
- Migration Assessment report with Road to Migration project.
- Outcome : Report contains – migration efforts, time and cost.
- There would be no actual conversion activity take place during the assessment program.
After Phase 0 completion, it enables for actual migration project initiation.
- After Phase 0 completion, it enables for actual migration project initiation. Customer will build the source database Test Env along with data to start migration activity Provide complete Read & Write access to Test Env
- Customer will freeze all the Database level changes on Source Database till the migration takes place.
- Shreeyansh team of migration experts initiate the migrations tasks as per the Assessment report
- Shreeyansh team install/configure tools/scripts as required during the migration project
- Provide all the necessary database commands and guidelines to perform at application level code changes. Customer application team own this responsibility.
- Shreeyansh team rewrite the code and work around wherever required to achieve the functionality
- For any advanced features where no work around possible from DB side, Shreeyansh and Application teams will try to achieve from application end with necessity developments.
- After Complete Database code conversion, Shreeyansh will build the Test Env with refresh of data to initiate application testing
- Application/Database fixes for application failures
- Performance and optimization tasks performed on Test Env
- Performance and optimization tasks performed on Test Env
- Build Pre-Live Env with latest data on PostgreSQL for Application user sign off.
- Plan and estimate downtime required for Live Implementations
- Management Approvals on Go Live & required downtime
- Hardware/Storage recommendation required Live Implementation
- Design PostgreSQL High Availability with Full Proof Architecture with auto fail over
- Auto fail over testing scenarios
- Review health check of the system for 2 weeks
- Fix database issues if any.
- Monitoring & alerts (Optional)
- Live Sign off
- Customer can maintain with their resource if expertise available Or Shreeyansh recommend options.
- Customer can avail PostgreSQL DBA Support (remote) options from Shreeyansh to maintain the system.
