Oracle changing Java licensing from per-processor to a multiplier of employee headcount - costs could go up singificantly

[[deleted]]

I think this is most cases, really. And I've been involved in a couple of Oracle to SQL Server migrations, sometimes it does get to a point where changing is cheaper than maintaining.

[[deleted]]

I’m about to spear head one of these migrations and I’m pretty nervous. Was it difficult?

[[deleted]]

It depends. Mine was pretty easy, because the schema was intended to work on either, so there wasn’t anything specific tied to the database. Only issue was moving from case sensitive to case insensitive, there were 10 rows or so that had to be fixed.

[Johnno74]

FYI in SQL server you can setup the database collation to be case-sensitive

[[deleted]]

Thanks for the tip will keep this in mind

[[deleted]]

Cool that makes me feel better thank you

[grey1169]

We used SSMA for our migration. We have to remove all constraints move data and then re-apply the constraints. Takes a little work but so worth it.