A blog by Oleg Shilovitsky
Information & Comments about Engineering and Manufacturing Software

PLM migrations and database wars

PLM migrations and database wars
Oleg
Oleg
22 August, 2012 | 2 min for reading

Migration. This is a word any IT and PDM/PLM manager is afraid to hear. In my view, it is one of the most painful things in enterprise software. The obvious reasons for migrations are related to IT infrastructure upgrades, need to move to the next PDM / PLM version and decision to switch to another vendor. The last one is not rare in the world or PDM/PLM mergers and acquisitions.

The core of any PDM/PLM system belongs to the database. Most of the systems in the market today are running on one of the available RDBS – Oracle, DB2, Microsoft SQL and maybe some others. Few days ago, I posted about PLM data models. PDM / PLM data model is part of any implementations. The way you handle it can make your migration process either smooth or nightmare. However, even the smoothest migration process is a complicated task that requires IT dedication and after-migration validation with customers. It takes time and cost money.

Recently, PLM vendors started to pay additional attention to the process of migration. Some of PLM vendors are including migration processes into their licensing terms by supporting to migrate from a previous version environment to a new one. SaaS /cloud vendors have the advantage of handling process of migration with limited exposure to end users.

The following article caught my attention few days ago – Oracle hurls MySQL at Microsoft database wobblers. Migration with a touch of Excel. The article represents an interesting perspective on database migration wars between Oracle and Microsoft. It resonated with potential migration problems customers may face when migrating between different PDM/PLM versions and/or products. The following passage emphasizes the importance of a smooth migration. It also presents the “competitive force” behind migration.

Under the latter category, Oracle is now throwing open source at Microsoft in the form of a migration tool to shift users off of Redmond’s latest database. Oracle new migration tools will move data from Microsoft SQL Server to MySQL, which Oracle bought from Sun. The tools come as part of the MySQL Workbench. Oracle claimed the migration tool would also shift database tables and data to MySQL and “quickly” convert existing apps. Oracle is also pushing its database as a back-end to Microsoft’s Excel.

What is my conclusion? The “data hostage” business is still a reality for database vendors and for many PDM / PLM providers too. I can see vendors will be more focused on how to reduce the hassle of data migration for customers. At the same time,  SaaS vendors will take an additional advantage of the cloud technologies to make migration process invisible for users. The target and demand of customers are how make information available. Just my thoughts…

Best, Oleg

Recent Posts

Also on BeyondPLM

4 6
9 September, 2016

Software is eating the world. Unless you’ve been living under the rock for the last few years, you know what...

31 December, 2023

Today is the last day of 2023. I find myself reflecting on the major themes and milestones that shaped Beyond...

8 January, 2011

One of my twitting buddies, Jonathan Scott, re-twitted the link to the following article – CIO Strategies: The Private and Public Clouds...

23 March, 2019

I’m coming to Aras PLM event (ACE2019). It has been a long time since I visited ACE event in person. Eight years...

12 September, 2013

I want to continue the topic of design interaction started in my CAD and Design Interaction: 50 years in 3...

24 March, 2021

Hexagon’s Article The Digital Thread Comes to BIM brings an interesting perspective on the industrial development of construction projects and...

21 December, 2009

A very short prompt this early European morning. Google is coming to the next Audi A8. Take a look on...

10 January, 2019

PLM was started few decades ago and it looks like coming to some sort of mid-life crisis. I can see...

12 May, 2014

My last post about Manufacturing BOM raised few interesting comments online and offline. One of them by Jos Voskuil  was pretty...

Blogroll

To the top