Is DTS the only way convert an Oracle database to SQL server 2000 database ?
-
Is DTS the only way to convert an Oracle database to a Microsoft SQL Server 2000 database ?
Are there any cool tools that can do the migration instead of using DTS which may be very cumbersome ?
-
It all depends on what you want to do.
If you only want to export tables along with data, then most etl tools will do this for you. Some of thenm allow you to transfer whole schemas in one go. or at least that's what they advertise.
If you want to transfer pl/sql packages etc into sql server, the only one I know if is one by the company SwisSQL. Search google to see all their different products. Not personally used them but know someone who has. Said it done the trick but was not exactly easiest to use.
Good luck.
------------------------------
The Users are always right - when I'm not wrong! -
As was just stated previously ... it depends on what you want to do ... but for data only there are products called Vitria and Informatica (if this is an ongoing data information exchange).
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
-
u can use link servers as well
My Blog:
http://dineshasanka.spaces.live.com/ -
You can use DataMirror Transformation Server to replicate and transform data between Oracle 7 onwards to SQL Server 6.5 onwards.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply