Oracle to SQL Server migration from an Oracle perspective
-
Hello
We are investigating the possibility of migrating from Oracle to SQL server. We are currently an Oracle shop and personally I have 10+ years of working with Oracle and I'm an OCP. So basically, I'm an Oracle guy. I've done some migrations from SQL Server 2000 to Oracle but never the other way round.
This isn't going to be a trivial task as we have a multi TB database with an enormous amount of code. What I need to do is get myself up to speed on SQL Server 2005 and 2008. I've got a good understanding of Oracle as a database and I understand some of the technical differences between Oracle and SQL server, such as transaction isolation levels, locking etc etc.
Are there any books or resources anyone can recommend that will help me get a good understanding of SQL Server development and administration?
Thanks in advance.
David
-
Your two primary sources of info for SQL Server are: 1) Books Online -which comes on sQL Server media and, 2) Microsoft Knowledge base -which is free at http://support.microsoft.com/ph/2855
Your post says you have a huge lot of code -THAT will be your real problem. There is no way to go from PL/SQL to Transact-SQL in an automatic way. Process is painfull, read the Oracle code, understand what it does, translate -rewrite- it as Transact-SQL.
Good luck!
_____________________________________
Pablo (Paul) BerzukovAuthor of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice. -
There is a free tool: the "SQL Server Migration Assistant" (SSMA) from Microsoft that can do much of the conversions for you, and guide you through the process.
Also there is an excellent and massive tome available for free download from Microsoft that describes many of the differences and provides a comprehensive planning guide for the whole process (I do not have the link at the moment...).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Hi PaulB
Thank you very much for the links and yes I completely agree, the big problem isn't data, it's code. I've worked on lots of systems where someone has used an automated tool to migrate code and it's been a disaster, so this would be a redevelopment from scratch rather than a migration.
To be honest, I don't think it's going to happen because we don't really see any advantage in moving - I don't think in this case that there are any pressing reasons to choose SQL Server over Oracle - other than management preference!
Even so, I think it's about time I broadened my horizons so I will do my best to digest the links you've provided.
Thanks again
David
-
You are more than welcome David.
I would suggest to go back to management with a report showing a honest estimate of effort and even proposing to do a pilot by migrating a small database or even a small schema of the target database.
If management prefers one RDBMS over the other it might not be a good idea a frontal attack against migrating to the one management likes the more; it would be much better if management -on their own- comes to the conclusion that the project is either not feasable or not cost-effective -providing that's the case
_____________________________________
Pablo (Paul) BerzukovAuthor of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice. -
This site, here, has a tremendous amount of resources to help you evaluate this and to help Oracle professionals understand the difference between Oracle and SQL Server.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Hi RBarryYoung
Sorry for not replying sooner - and thank you for the links that you provided. My internet connection died just after my last reply so I didn't get a chance to reply to you too.
Anyway, thanks again for the links - I'll look forward to trying to absorb them!
David
-
Glad I could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply