SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Oracle 10G to SQL Server (2008 and above)DB migration process


Oracle 10G to SQL Server (2008 and above)DB migration process

Author
Message
mtz676
mtz676
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7492 Visits: 1607
Does working on an Oracle DB 10g database migration to SQL Server using SSMA involve more of Oracle work or SQL Server work?
Can anyone please provide a brief description of the process.
Thanks
kevaburg
kevaburg
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16142 Visits: 1283
Hi,

the question is more than a little vague to be honest.

if you use the SSMA to migrate the EXAMPLE Schema from Oracle to SQL Server 2016 it performs the process very smoothly and with very little additional effort.

However.....

there are some restrictions to using the Assistant. For example there is no support for user defined datatypes so if you use them then you are going to have to rewrite your code to integrate them into the new database. Information about these restrictions about aplenty on the MS Website and the documentation for it is very good.

I strongly recommend trying out a test Migration using the shipped example database, generate a Report and use the test case tool to figure out what will work and what won't. Unfortunately there is no clear answer to you question.

Experience is the teacher here.....

Rgeards,
Kev
Lowell
Lowell
SSC Guru
SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)

Group: General Forum Members
Points: 292686 Visits: 42065
also in my experience, every trigger,package,procedure and function in oracle will have to be rewritten, even when they is doing the most trivial CRUD operations, and especially because the way Oracle treats sets of data is more row-based centric , where SQL is set based centric.
those objects don't have a clean upgrade path the way tables and views do. you'll need to get a developer working on this early, because just mapping the data types and migrating the data is actually pretty straightforward.

I was in on a project that did that, the data was easily moved to development in a day, and then it was all developers on hand converting procedures to SQL server, and then changing application to see if they worked on the new RDBMS. it took several months before it was bulletproof.

Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search