Hi!
I need to wake up this thread again just to check if anyone has successfully done a migration of the SDM MDB from Oracle to SQL Server? We have a SDM installation that is not integrated with any other CA products so I am hoping that it will be possible to just use pdm_backup and pdm_restore. But that surely seems a too simple solution to this problem? :-)
We do not have access to a test environment with Oracle yet, so I am just polling the community to see if someone has any experience of doing something similar.
I have seen other posts that mention 3rd party tools to migrate MDB-data between database platforms, for example using SQL Server Migration Assistant (SSMA) for Oracle:
SQL Server Migration Assistant for Oracle (OracleToSQL) | Microsoft Docs
Is that another altenative in my case?
I have received the following advice from CA Support:
"You may use pdm_backup, but it does not cover non-SDM tables (used by integration with other CA Products). Tecdoc TEC471268 What does pdm_backup do? What is the difference between pdm_backup and pdm_extract?"
https://support.ca.com/us/knowledge-base-articles.TEC471268.html
provides some steps on how to do that. "
There is also a Tecdoc that describes how to reconfigure SDM to use SQL Server instead of Oracle but that does not describe how to actually migrate the MDB-data:
How to configure Service Desk Manager to point to a different database platform then it does currently
Best regards,
Heikki Ikonen
Netgain