Re: Migrating from Sybase

From: <mjwalsh_at_hotmail.com>
Date: Wed, 21 Jul 1999 12:16:55 GMT
Message-ID: <7n4dng$qcb$1@nnrp1.deja.com>

Oracle have a group called Design and Migration Services which produce migration kits including a Sybase to Oracle migration kit. It claims to migrate data and stored procedures.

I have had some bad expierences with it though, mostly on the stored procedures side.

Depending on the numbers of tables involved I would prefer a manual approach. For example I would used an ERD modelling tool with reverse- engineering capabilities to migrate the databases/schemas. And I would use bcp and sql*loader to move the data. This might be time consuming but it is more predictable.

regards

MJW Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 21 1999 - 07:16:55 CDT