Reply to post: Re: Migration

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

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