Microsoft attempts to eat Oracle's database lunch with Azure migration service

Microsoft is launching a database migration tool to help Oracle users shift to a PostgreSQL managed service on Azure. Coinciding with Redmond's Ignite bash, the vendor is offering Azure Data Studio, a cross-platform database assessment tool, to help switch from Big Red to a Microsoft PostgreSQL-compatible managed service. …

[Il'Geller]

Microsoft a few years ahead of Oracle. So it could. Interesting to know how far Microsoft is, though… But this is a secret, I guess.

[VoiceOfTruth]

Interesting that MS is a PostgreSQL sponsor

-> Microsoft is launching a database migration tool to help Oracle users shift to a PostgreSQL managed service on Azure

Microsoft is on the list of "Major Sponsors" on the PostgreSQL project web site. For those who don't want SQL Server perhaps MS is hedging its bets, AKA the Apple investment from which they did very well.

[AMBxx]

Re: Interesting that MS is a PostgreSQL sponsor

Looks like a clever move. If EDB can sell proprietary extensions to Postgres, MS can do well with similar. I'd like to see Postgres support in SSMS (think I might have a while to wait).

Interesting bit will be when they try to differentiate SQL server and Postgres. What are the benefits on MS SQL now?

[disgruntled yank]

Migration

I suspect that most organizations that use Oracle have quantities of PL/SQL: triggers, packages, etc. They do not have this for decoration, rather to enforce and implement business rules. Now, while you or I can more or less unconsciously translate Oracle DDL to SQL Server or Postgres DDL, what happens to the stored code? T-SQL is very different, and so I think are the various flavors of Postgres stored code.

[Anonymous Coward]

Re: Migration

"I suspect that most organizations that use Oracle have quantities of PL/SQL: triggers, packages, etc. They do not have this for decoration, rather to enforce and implement business rules. Now, while you or I can more or less unconsciously translate Oracle DDL to SQL Server or Postgres DDL, what happens to the stored code? T-SQL is very different, and so I think are the various flavors of Postgres stored code."

I think, like all Azure DB migration tools, this one will have an assessment mode, by which it will tell us what is incompatible with the target engine.

At least, you'll know and will be able to address it, before the big jump.

Interesting discussions between devs who have long forgotten why tris trigger, stored function or whatnot, and infra people looking to do millions in savings ...