Database Migration

Most commercial solutions use some kind of backend database, in many cases the database management engine is based on costly and expensive in maintenance Oracle RDBMS. For some systems reaching end-of-life may also mean that data must be moved from a legacy solution to a modern platform.

In cases such as described above it is recommended to preform database migration to an open-source database, such as MySQL. Obviously MySQL is only one possible option – other database management systems like PostgreSQL, MongoDB or Cassandra can also be considered. DB selections depends on type of stored data, amount of data, data flow and usage patterns. For some applications using LDAP instead of a relational database would give the best gains.

In any case ProIDS can help your organization with data transition. We have hands-on experience with migrating legacy solutions including Oracle to Oracle and Oracle to MySQL swaps. We transferred data from large scale systems, being used commercially. Where applicable (e.g. old and new systems must operate in parallel during an extended period) we setup a dual-provisioning solution which allows transition of data over a longer time window (multiple days or weeks).

The approach which we use typically consists of following steps:

  • Data architecture assessment
  • Recommendation of target options for data-store
  • Data mapping definition
  • Migration procedure preparation, including assessment if a dual-provisioning solution is required
  • Development of data manipulation tooling (extraction, conversion, insertion)
  • Preparation of required tests
  • Verification of migration process on test system
  • Setup of dual-provisioning (if applicable)
  • Execution of migration on production system
  • Cleanup of legacy solution

About us

ProIDS logotype

After long time of being a part of huge multinational corporation in IT industry we detach ourselves and started ProIDS. And we took our skills, experience and customers’ trust with us. That’s why we like to say we did not come out of nowhere – we came out of shadow. And where are we heading now? Same direction as IT world. And we keep pace with it.

Drop us a line


Name
E-mail
Subject
Message

Contact us

Warsaw Office
Starościńska 10-12 Lok.1
02-516 Warsaw, Poland
Phone+48 222 991 476
Dubai Office
ProIDS LLC
Media City, Dubai
Phone+971 56 67 68 083
Headquarters
ProIDS Sp. z o.o.
Tagore 1/74
02-647 Warsaw, Poland
E-mailinfo@pro-ids.com
   

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this. In the same time notice that our website gathers anonymous statistics with Google Analytics tool.

Close