Guidance for migrating SDM from Oracle to SQL Server

Document ID:  TEC1602775
Last Modified Date:  06/16/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Service Desk Manager

Releases

  • CA Service Desk Manager:Release:12.9 CA SDM
  • CA Service Desk Manager:Release:14.1
  • CA Service Desk Manager:Release:17.0

Components

  • UNICENTER SERVICE DESK RXX:USRD
Introduction:

There is a scenario where the customer is running Service Desk on Oracle since previous versions, but because of many reasons (ex. licensing, internal policies, costs) the customer is going to adopt Microsoft SQL Server as their corporate database. Now that they are planning to upgrade Service Desk to a newer version, they would like to take advantage of this opportunity and also migrate it from Oracle to Microsoft SQL Server.

Question:

How to take advantage of a Service Desk upgrade to migrate the database from Oracle to Microsoft SQL Server?

Environment:
Service Desk 17 Service Desk 14.1 Service Desk 12.9
Answer:

If you plan to change the database from Oracle to Microsoft SQL Server for Service Desk usage, there is no documented procedure how to migrate between these two types of database because databases are third-party products. However, from the Service Desk perspective it can be similar when test/QA servers with production data is built. In that case, only data is moved from production to other environments, including few parameters that can be moved manually. In the case of changing the database vendor, it has a similar approach, because data can be moved through the Service Desk tier, without being specific regarding the database.

It means you are able to move data using Service Desk tools such as pdm_extract/pdm_backup and pdm_load/pdm_restore.

On the other hand, if you wish you can use database tools to move around the data from one database to another. Check in Microsoft SQL Server or Oracle side if there is any procedure for moving data between them. You have to talk with your database vendor in order to find ways to migrate databases between different vendors.

Additional Information:

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >