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
28 July, 2009

My short conclusion after very productive discussion about how to move PLM to mainstream. First of all, I enjoyed it...

2 April, 2020

I attended the first virtual CIMdata PLM market forum last week. If you missed my earlier article check them here...

15 May, 2010

This is a weekend post. I was trying to find a way to present in one page what I’m blogging...

14 May, 2011

I’ve been watching updates from the Google I/O 2011 conference during this week. Google came with the announcement of Chromebook....

30 April, 2021

Yesterday’s SaaS PLM comparison article triggered great sparring with my long-time PLM industry colleague, Marc Lind, SVP of Strategy at...

20 March, 2009

 I’d like to start  a wide topic for discussion – BOM. Yes, Bill of Material. This may seem like an...

15 January, 2009

Even though, 2008 was year of financial crisis and instability, I still regard it as a remarkable year for the...

6 July, 2017

Engineering.com just published an article confirming that small design and engineering team aren’t interested much in buying and implementing data...

9 April, 2010

I’d like to follow my yesterday post about PLM data modeling and talk about one of the issues that in...

Blogroll

To the top