back to article 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. …

  1. 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.

    1. This post has been deleted by its author

  2. 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.

    1. AMBxx Silver badge

      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?

  3. 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.

    1. Anonymous Coward
      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 ...

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

Other stories you might like