But if you have the source code, and you have (or can hire/contract) the expertise, you can move the applications. The occasional really complex app might take many person-months or person-years to move. Others can be moved pretty easily with the tooling provided by AWS or others, with days to weeks of work. Sure many apps can be manually moved over with a few hours or days of work. But that isn’t the real story of what it takes to move away from Oracle. Or, maybe in rare cases, the difficulty achieving the right level of technological parity. On the surface the move away from Oracle database is purely a balance between the cost of switching technologies and the cost of sticking with Oracle. But a bunch of them clearly have Oracle as the source, and something non-Oracle as the destination. Note that Andy isn’t specifically saying 50K migrations off of Oracle, that’s the total number for all sources and destinations. Including to Aurora MySQL, Aurora PostgreSQL, and Redshift which, take advantage of the cloud to provide enterprise-level scalability and availability without the Oracle licensing tax.Īnd just 1 mo after hitting 45K DB migrations, we pass 50K mark (w Holidays downtime mixed in)…pace continuing to accelerate #DBfreedom #AWS The AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) have allowed many applications to be moved off of Oracle to other databases. And, of course, the most talked about effort the last few years is the one by AWS. IBM has a similar effort for DB2, which includes its own PL/SQL implementation. They re-invigorated that effort last year. Microsoft started a major push on migrating Oracle applications to SQL Server back in the mid-2000s with SQL Server Migration Assistant. They target direct execution of ported applications by adding PL/SQL-compatibility with its SPL, support for popular Oracle pre-supplied packages, offering an OCI connector, and other compatibility features. There are PostgreSQL-derivatives like Enterprise DB’s Postgres Advanced Server that go much further than just providing an Oracle-equivalent. The entire PostgreSQL community has had making that possible as a key priority for many years. ![]() ![]() There are a ton of efforts out there to make it easier for customers to move off of the Oracle database. Tl dr It might not be possible to completely migrate off of the Oracle database, but lots of companies are capping their long term Oracle cost exposure. And a little on Amazon (Web Services) in databases. I’m not going to comment specifically on Amazon, or Salesforce, and any attempt to move away from Oracle’s database. A bunch of news stories, apparently coming off an article in The Information, are talking about Amazon and Salesforce attempting to move away from the use of Oracle.
0 Comments
Leave a Reply. |