shipra pandey
02-21-2006, 11:51 PM
How can we transfer full database including tables,stored procedure ,trigger,function etc from Sql 2000 to Oracle
Click to See Complete Forum and Search --> : How to transfer database from MsSql2000 to Oracle
Wiseman82
02-26-2006, 11:11 AM
Any particular reason for the migration?
How easy it is to transfer to Oracle probably depends on the database and how much you have used T-SQL extensions. You might have to re-write many of your stored procedures, functions and triggers.
In many cases, switching database vendors is not the answer to solving performance problems. I've not had the pleasure of migrating to a different database vendor myself, so other users can probably offer you better advice.
How easy it is to transfer to Oracle probably depends on the database and how much you have used T-SQL extensions. You might have to re-write many of your stored procedures, functions and triggers.
In many cases, switching database vendors is not the answer to solving performance problems. I've not had the pleasure of migrating to a different database vendor myself, so other users can probably offer you better advice.
Sync
03-07-2006, 05:00 AM
MSSQL-to-Oracle
http://www.convert-in.com/mss2ora.htm
It doesnt cover store procedure.. :( and not freeware..
I think MS SQL 2000 is very powerful database server.
Why do you want to migrate to Oracle? cuz' so boring? :P Just kidding. :-)
Have Fun!
http://www.convert-in.com/mss2ora.htm
It doesnt cover store procedure.. :( and not freeware..
I think MS SQL 2000 is very powerful database server.
Why do you want to migrate to Oracle? cuz' so boring? :P Just kidding. :-)
Have Fun!
Wiseman82
03-07-2006, 06:40 AM
MSSQL-to-Oracle
http://www.convert-in.com/mss2ora.htm
It doesnt cover store procedure.. :( and not freeware..
I think MS SQL 2000 is very powerful database server.
Why do you want to migrate to Oracle? cuz' so boring? :P Just kidding. :-)
Have Fun!
Considering the price of Oracle licensing (I'm assuming the migration is not to Oracle Express), $49 isn't going to break the bank. I doubt this tool will make the migration a whole lot easier though - I don't think any tool will make this a simple task. You'll be left to re-write any sp's, triggers and functions manually with the tool above - to be honest I don't think I'd trust a tool that did this automatically. It might be worth hiring a consultant to assist with the migration - Again, think carefully if you really need to do this – you should have strong justifications for the migration.
http://www.convert-in.com/mss2ora.htm
It doesnt cover store procedure.. :( and not freeware..
I think MS SQL 2000 is very powerful database server.
Why do you want to migrate to Oracle? cuz' so boring? :P Just kidding. :-)
Have Fun!
Considering the price of Oracle licensing (I'm assuming the migration is not to Oracle Express), $49 isn't going to break the bank. I doubt this tool will make the migration a whole lot easier though - I don't think any tool will make this a simple task. You'll be left to re-write any sp's, triggers and functions manually with the tool above - to be honest I don't think I'd trust a tool that did this automatically. It might be worth hiring a consultant to assist with the migration - Again, think carefully if you really need to do this – you should have strong justifications for the migration.
devx.com
Copyright Internet.com Inc. All Rights Reserved
Copyright Internet.com Inc. All Rights Reserved