| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-29 : 09:34:24
|
| Raj writes "Hi,Has anyone attempted or successfully completed a migration from Oracle to SQL Server 7? We are going to go to a one platform system in about a month and I need some advice. Thanks and any input is appreciated. Raj Antony V" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-29 : 18:19:05
|
| Raj,I have imported tables from Oracle into SQL Server 7 and 2000 using DTS. I have only done a few of them, but have not had any troubles. The big challenge will be Oracle Procedure and Packages and triggers. Basically, I don't know of any really good converter for these, and the systems are different enough in syntax that you'll probably be better off re-writing each one by hand.Good luck!------------------------GENERAL-ly speaking... |
 |
|
|
Nazim
A custom title
1408 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-03-30 : 10:31:05
|
| You will probably find that Oracle is a lot more tolerant of poor design / innefficient coding and so it is worth looking at redesigning the system for the migration. You should find that sql server will work faster if designed properly.All the Oracle people I have worked with have had very little knowledge of relational databases and have tended to treat coding as procedural like a front end - hence think that sql server is very slow (which it is if treated like this) so you may have some retraining to go through.Anyone who says that cursors are faster than set based queries should be asked to prove the statement and buy lots of beers - I have had that said about Oracle at two companies but never had it proved.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-30 : 10:52:38
|
was wondering nr, doesnt thtat imply that oracle is a better product coz it can handle a bad design too. A bad design , irrespective of the system it is using. would lead to unnecessary complexities and might end up in a total chaos. quote:
You will probably find that Oracle is a lot more tolerant of poor design / innefficient coding and so it is worth looking at redesigning the system for the migration. You should find that sql server will work faster if designed properly.
--------------------------------------------------------------Edited by - Nazim on 03/30/2002 10:54:46 |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-03-30 : 17:42:16
|
| I would say not.I recommend companies to take Oracle if they have no expertise or are not interested in gaining it - but to expect to have serious problems at ome point in the future.To use sql server if they want a more efficient system.SQL server is easier to get working at all, Oracle easier to get some sort of performance out of, SQL server easier to get good performance.That's without knowing a while lot about Oracle but from having ported systems and talked to Oracle people who say 'this would work on Oracle' (even though it's crap).==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-31 : 00:57:06
|
And I wouldn't recommend Oracle at all( Even if they are going to install it in hell to punish the DBA's for their sins )  quote:
I recommend companies to take Oracle if they have no expertise or are not interested in gaining it - but to expect to have serious problems at ome point in the future.
-------------------------------------------------------------- |
|
|
|
rajantonyv
Starting Member
12 Posts |
Posted - 2002-04-01 : 08:52:48
|
| Thanks guys for your help. Wish me luck,Raj Antony VRajesh Antony Vattakunnel |
|
|
|
|
Migrating To SQL Server From Oracle 7