Database migrations
How it works
Databases are frequently the core digital asset of modern businesses, and as such, migrating those workloads requires experience and an uncompromising attention to detail.
We differentiate our database migration services by combining a rigorous process with a cutting edge collection of data migration tools that can't be found anywhere else. Our experience delivering over 25 database migration projects (and counting!), combined with the experience of developing Albatross and a related set of internal scripts gives us the ability to adapt to unique and challenging situations.
Methodology
We constantly update our methodology to accommodate new ideas, account for new edge cases, and improve safety. You can read our full methodology, which we release for free, in our [database migration guide](link-to-guide). A quick summary of each step in the process is as follows:
- Evaluate current system
- Compare possible migration targets
- Establish development environment
- Migrate schema (tables, stored procedures, etc)
- Migrate data
- Assist with client migration / testing
- Perform fail over in staging environment
- Perform fail over in prod environment
Each step in this process is a complex endeavour unto itself. However, you should expect the most time to be spent migrating your schema, especially if you have complex stored procedures or have made use of vendor specific features that aren't available in your elected target.
Pricing & timeline
We charge $150 per hour for our time and can bill in any currency accepted by Wise.com.
Migration projects with low complexity and just a few databases will take 1-2 months and cost $10,000 - $20,000. For projects with dozens or hundreds of databases or high migration complexity, contact us for a quote.
Your individual project's timeline and cost will depend on these factors:
- How many databases do you have to move?
- How complex are those databases?
- Some tasks can only be completed by your team - will they be completed quickly?
- Is your migration target client-compatible* with your current database?
* Client-compatibility means that your new database "speaks the same language" as your old database. For example, AWS Aurora and MariaDB are client-compatible with MySQL, and will require very little (if any) time spent on schema migration.
Albatross Migrations
Albatross Migrations is now a separate company focusing exclusively on database migrations, powered by the core team behind SQLpipe. Please visit our new website albatrossmigrations.com to learn more and get started.
