Migrate Oracle to SQL
-
Did anyone migrate Oracle DBs to SQL? What tool is the best? any suggestion?
-
One of our authors, Haidong Ji, has written a little about it. There also was a competition from Microsoft and they provide a free tool to help you migrate:
-
I actually teach a lot of SQL to Oracle courses, including the SQL Server Migration assistant. The tool from Microsoft is great for eliminating a lot of the tedious, manual steps. The big caveat is how will the application take the change? It isn't that complicated to move the database from one platform to another (there are differences in data types, yes, but usually the conversion is obvious). The problem is going to be the business logic (in Oracle a great deal tends to reside in the database) and the further training of DBAs and developers to change their assumptions and habits (e.g., cursors are ubiquitous in Oracle, but should be avoided in SQL Server whenever possible).
One other tidbit - migrating to SQL 2000 is more complicated than moving to SQL 2005. Why? 2005 has a number of features that Oracle already supports, like true schema usage, synonyms, etc. If there is a choice in the matter, move to SQL 2005 whenever possible.
OK, 2 cents contributed, I'm off my soapbox
-
Good point. Can SSMA be used for Oracle to SQL 2005?
-
As is, sort of. The 2.0 version should if I'm not mistaken. Best to go to http://www.microsoft.com/sql under the migration section for the latest info.
-
have anyone better experience with the ssma tool and great databases,
pleae let me know.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply