Database migration - Oracle to SQL Server

Question

Hi,

We are looking at migrating our JIRA database from Oracle to SQL Server. I have made a script to create all of the tables present in Oracle in SQL Server and have copied the data in through a database link for most of the tables.

However, I am having an issue with copying the data from the tables with the CLOB data type over to SQL Server. It is extremely slow to select this data compared to tables with varchar2(255) data types for example. Has anyone had any experience with this issue?

Aside from the tables, would there be any other concerns when migrating the database to a different platform? For example other database objects?

Please note: We found the XML backup to be too slow and the migration would not have been able to complete out of hours. The JIRA version is 4.3.

Thanks for your help,

Mike

Alex Nelson3 · Answer

I found the guide: http://confluence.atlassian.com/display/JIRA044/Switching+Databases#SwitchingDatabases-MigratingJIRAsDatatoaDifferentTypeofDatabaseServer

Alex Nelson3 · Answer

We are hoping to do the same as SQL Server is much less expensive for us.  Any guidance would be appreciated.

JamieA · Answer

I think you need to make the XML backup fast... it's the safest way to do it. What part of the XML dump/restore method is slow?

On my oracle instance xml backup is excruciatingly slow, but I can copy the data quite quickly from the production oracle server to oracle XE on a workstation using data pump. Then run a jira instance pointing to this oracle XE, and I can get the XML backup quite quickly.