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

Migrations and PLM World

Migrations and PLM World
olegshilovitsky
olegshilovitsky
31 August, 2010 | 2 min for reading

Microsoft announce SQL Server migration assistant for MySQL. It seems to me, Microsoft is thinking about how to expand their SQL tool’s market share. As a step towards this direction Microsoft is thinking how to provide an easy and smooth way to migrate from one data management system to another. I’m not an expert in database migrations. However, reading about Microsoft migration tools made me think about migration between different PLM and PDM systems in manufacturing world.

Reasons to Migrate

What if.. you want to migrate from one PLM system to another one? Such a situation is not completely rare and companies are moving between tools and product suites due to different things happens in PLM eco-system. Such a situation may happen as a consequence of M&A when companies are merging their IT stacks and PLM systems used by companies before or after acquisition. In addition, customers are deciding to move into a better tool – another "good" reason for migration. At the same time, there are multiple situations when customers need to migrate between PLM tools because vendors going out of business, software companies acquisitions and other reasons. What happens if you are migrating between systems, and you don’t have an appropriated tool? I decided to put few options that can give you some values in product migrations.

Migrate vs. Legacy

However, to migrate between systems is not a simple task. It takes time and requires a complex set of tasks to move data, change working processes and tools. In some situations, companies prefer to keep existing systems and use data inside as a legacy data. This cannot be considered as an excellent choice. However, in a business world, it can be a very reasonable compromise. Some PLM companies are providing federation systems that can help to maintain such situations.

Mashups

Another option to resolve the situation with outdated PLM/PDM system. You can decide to develop mashup applications. This is a very popular practice in the Web world. You can develop mashup applications to consume a data located in outdated or legacy PLM/PDM systems. The consumer (user) layer will be new and fancy. Behind the scene, the legacy system will be kept up and running.

ETL and Other Integration Tools

This is another way to handle a transition of data between your old PDM/PLM and a new one. ETL (extract-transform-load) tools can allow you to retrieve data in a variety of formats from databases and proprietary data sources, transform it and transmit into a target system.

What is my conclusion? I think, PLM migration topic is a very complicated one. Changes in multiple systems, different versions, customization and implementations made this space a bit messy. To put some lights into this space can be benficial for users and vendors.

Best, Oleg

Recent Posts

Also on BeyondPLM

4 6
4 March, 2009

We finally succeeded to have interview online between our office in Boston, MA and DS office in Paris. Thanks, Kate! Meet...

13 March, 2023

An interest in AI is spiking. ChatGPT touched the nerve of many people and it is on the mind of...

30 March, 2018

PLM implementation projects can stuck. Unfortunately, it happens a lot. It is actually happens more often than you can think...

13 June, 2025

Technology matters. One of the technological topcis that drives a significant misunderstanding – multi-tenant systems. If you’ve been around PLM...

16 August, 2024

For many years, CAD/PLM – ERP integration was a topic that triggered many questions. As you probably note, I put...

10 June, 2023

Earlier this week, my attention was caught by a CNBC article Firms are bringing production back home because of the...

13 March, 2009

As you know, new ideas often come from things already forgotten… Therefore, I like looking at research projects and experimental...

13 June, 2017

Experience is a new mantra in our world. Software vendors are taking it sometimes to extremes by starting to offer...

26 August, 2019

I’m in San-Diego to attend IpX ConX19 event. Yesterday, I spent half-day visiting USS Midway. It was my second visit...

Blogroll

To the top