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
19 November, 2013

Three years ago I sat together with Hardi Meybaum of GrabCAD is one of Starbucks coffee shops near Brookline, Mass....

16 October, 2012

PLM and marketing are not good friends. Marketing did a poor job for the last 10 years for PLM. For...

22 July, 2016

CAD files is a real nightmare for any data management system. Because of complex relationships, dependencies and size, to manage...

22 October, 2012

I’m going to attend PLM Innovation Americas event later this week in Atlanta, GA. This is going to be my...

7 July, 2013

One of the looongest US weekends I remember  is going to end. This is a time to get back from...

16 September, 2023

Earlier this week I attended Digital Factory 2023 event organized by Formlabs and Autodesk. The event took place in the...

12 July, 2010

PLM is certainly dealing with lots of data about products: design, engineering, lifecycle data, manufacturing, processes. When/If you speak to...

2 July, 2023

Andrew Sparrow’s article Top 8 Trends Shaping the Future of MES caught my attention earlier this week. The article speaks...

19 December, 2014

Have you heard about collaborative economy? If you are not familiar with the term, it is a time to get...

Blogroll

To the top