Success needs expertise.

Successful migration from Oracle to MSSQL

Since 1995, Dr. Wallner Engineering GmbH has been supporting Körber AG in various PLM projects – from migrations and method development to training and multi-site consolidations. Another key project followed in 2024: the migration of the Teamcenter database from Oracle to Microsoft SQL Server (MSSQL).

 The challenge
Due to technical and licensing requirements, particularly when using virtual environments, the existing Oracle infrastructure had to be replaced. After evaluating various approaches, the direct table migration method was chosen because it enables short rollout times and maximum control.

The solution
The project included preparing the infrastructure, an OOTB Teamcenter installation, test migration, customer testing, and the productive rollout. Data was transferred via CSV export and import, which proved to be the most efficient method for large amounts of data. Parallel processing of multiple tables further reduced the runtime. After a four-week test phase, the productive migration was successfully completed – without the need for a fallback, as the Oracle source remained unchanged.

The result
The migration went smoothly and on schedule. During the subsequent stabilization phase, performance optimizations were implemented to further increase system efficiency. All migrated databases are running stably and error-free – proof of the high quality and reliability of the solution used.

Would you also like to migrate your production environment or implement modern processes? How can outdated methods be replaced? Let's find out together. Book a free consultation with an expert from our team.

Request expertise now

Increased efficiency through consolidation

Together with Leistritz AG, we have merged several existing Teamcenter & NX installations into a uniform, future-proof system landscape.

The challenge
Four business units worked with five different Teamcenter & NX environments spread across 29 servers and 10 SQL databases – with differing software versions, data models, and configurations. A particularly demanding task was to standardize the individual BMIDE extensions without restricting the users' familiar working methods.

The solution
During the course of the project, databases, file servers, and Teamcenter servers were consolidated to just eight servers and two SQL databases. In addition, a uniform version status was created for Siemens NX & Teamcenter. A central data model, cleaned up and extracted from the existing systems, now forms the common basis. 

Data from older instances was successfully migrated using ReClass tools and MultiSite Transfer. A shared PLM share provides standardized startup scripts, central NX tools, and user-specific configurations.

The result
Consolidation led to significantly simpler administration, higher system efficiency, and improved collaboration between business units. The shared database makes updates, data exchange, and maintenance much faster and more transparent. New workflows, localized user interfaces, and uniform drawing frames make the system landscape future-proof.

Are you wondering how you too can increase your efficiency and make your collaboration more agile? Let's find out together. We support you with tailor-made solutions for smooth implementation.

Get support now

Pump it up

In the design department for concrete pumps, the task was to develop an efficient method for creating 3D models in order to cope with complex requirements. Due to the wide range of pump variants, a flexible model was required, especially for installation space and installation investigations. A central data model that combines all available components replaced the time-consuming search in the SAP system and significantly increased efficiency.

The team opted for the Teamcenter product configurator to manage the assemblies. This enables structured handling of the components and variants. One challenge was the exact positioning of the components. The aim was to minimize the effort required for constraints and at the same time avoid errors.

Using the Teamcenter product configurator has not only improved clarity, but also significantly reduced the effort required to model and configure concrete pumps. Assemblies can be configured efficiently by selecting the desired components. These are then automatically placed in the correct positions using assembly constraints, which significantly reduces manual positioning and the susceptibility to errors. This speeds up the entire process and ensures greater precision when configuring the assemblies.

Would you like to know how the Teamcenter Product Configurator works in detail and try it out for yourself? Then take a look at our Learning Nugget “Product Configurator” – compact, easy to understand and ideal for getting a taste of the topic.

Get to the Learning Nugget

Strong together

Our collaboration with Schmitz Cargobull kicked off in April 2018 when we joined the ONE R&D and ONE PLM project. Since then, we have continued to develop together and have been able to implement numerous important milestones from 2020 as part of EA CAxPLM (Enterprise Applications) under the leadership of Klaus Schulze Ameling.

Our core tasks in the ONE R&D and ONE PLM project included the implementation of an efficient document management system and standard parts management in the Reuse Library. We also successfully implemented the project and business requirements in the Teamcenter environment, which went live with TC11 and NX12 in November 2018.

Another significant step forward was the move of the engineering environment to the Microsoft Azure Cloud in March 2020, where we took over the architecture and installation of the new cloud environments as well as the migration of the database from Oracle to Microsoft SQL Server. The successful go-live with TC11 and MS SQL took place in June 2020. We then implemented the migrations to TC12 and TC14. We are currently working on the migration to TC2406.

In addition to these large projects, we continuously implement ongoing business change requests in the corresponding Teamcenter releases in order to meet the dynamic requirements.

Durch unsere umfangreiche Expertise und Er­fah­rung in der Implementierung komplexer PLM-Lösungen können wir Schmitz Cargobull maß­ge­schnei­der­te und zukunftssichere Systeme bieten, die eine nahtlose Integration von Do­ku­men­ten­ma­na­ge­ment, Normteilverwaltung und Businessanforderungen ermöglichen. Damit erreichen wir eine höhere Flexibilität und Ska­lier­bar­keit, sodass Schmitz Cargobull optimal auf­ge­stellt ist, um effizient auf sich verändernde Marktbedingungen zu reagieren und ihre Ent­wick­lungs­pro­zesse nachhaltig zu optimieren. 

Are you also planning a system installation, migration or an update of your PLM environment? Benefit from our experience from numerous other successful projects - we will support you with customized solutions for a smooth implementation.

Get expert consulting support today