I want to now if is possible the migration of a data between MS SQL and Oracle, in a upgrade of SDM 14.1 to SDM 17.1
And if possible, what requirements are needed to achieve migration
SDM version 14 cum #4
SO W server 2012 R2
There is no out of box functionality that will migrate data between SQL and Oracle.
Has any other Community Member successfully migrated data between SQL and Oracle?
If not, CA Services would need to be involved to assist with this.
I have not tried this and the link instructions seem to apply only to a limited number of MS SQL versions, but it may provide you with a start on the DB side of things:
SQL Server Migration
This still does not cover the SDM application side of a migration. The general steps for promoting SDM between environments would be a good start: (I would not try to run the actual utility.)
CA SDM Environment Promotion
To follow on what J.W. noted, we generally suggest only changing one aspect of the environment at a time. If you're planning on changing both the version of Service Desk Manager and your database architecture, I'd strongly recommend choosing one or the other and handing that change one item at a time. Trying to change out both the database and the product version could cause any number of issues, and there are just too many moving parts to reliably identify any issues you might encounter. An added benefit of doing this one step at a time is that you have a good place for backups / snapshots in between, which will help in case you find a need to roll back / restore in case of problems.
Hi varelafpy ,
I've been using pdm_backup.
"If you consider to use SDM utilities, then the option is to use pdm_backup and pdm_restore commands. Tech document TEC471268 contains information about files and tables which are collected by pdm_backup command." By Naveen_Desham on Has anybody migrated an Oracle MDB to MS SQL Server?
What does pdm_backup do? What is the difference be - CA Knowledge
Retrieving data ...