Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lionofdezert
Aged Yak Warrior
885 Posts |
 Posted - 2008-01-24 : 03:05:54
|
| Our clint need to migrate from already runner database on SQL SERVER 2005 to Oracle 9i, WHAT will be basic and important issue we will face in this term and HOW we will handle with our functions and procedures created in SQL SERVER 2005 database... ???regards |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-24 : 04:15:04
|
| there are many sql syntax differences, there are major differences between the procedural TSQL and Oracle PL/SQL, there are datatype differences, etc.Oracle provides some migration tools that you might want to look at. They might help you get started. I believe they can be found at http://technet.oracle.com-ec |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-01-26 : 02:39:03
|
| only detail document i found on migration ....http://download.oracle.com/docs/cd/E10405_01/doc/appdev.120/e10379/toc.htm |
|
|
|
Richard101
Starting Member
30 Posts |
Posted - 2008-01-26 : 04:04:52
|
| thing is, sql-server and oracle work different. you cannot treat like a big data bucket that your apps can get data from. some parts of your apps will need to be re-written or they will crawl - at best.my advise, through money at a specialist. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
|
|
Migration from SQL SERVER to ORACLE