Re: SQL Server to Oracle

Hi

If it is purely data that is moving, and the logic sits in the app, then I'd go for microsoft's DTS. The moment you start having logic in the database (and that is the first, if not the only, place that I'd put it) I'd look at something like the Oracle Migration Workbench to generate a (probably) working app for a developer that knows and understands both systems well to work on. (this ain't cheap unless you happen to be both an Oracle and SQL server house already).

Niall

On 2/13/06, Michael.Coll-Barth_at_verizonwireless.com < Michael.Coll-Barth_at_verizonwireless.com> wrote:
>
> Hi,
>
> We are about to move a small application from Windows / SQL Server to AIX
> / Oracle 9.2.0.6. Any thoughts on how to move the data over in as
> painless a manner as possbile? Of course, there is no budget for tools. I
> have only the software that comes with these products.
>
> Any thoughts / help would be most appreciated.
>
> Michael
>
>
> The information contained in this message and any attachment may be
> proprietary, confidential, and privileged or subject to the work
> product doctrine and thus protected from disclosure. If the reader
> of this message is not the intended recipient, or an employee or
> agent responsible for delivering this message to the intended
> recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.
> If you have received this communication in error, please notify me
> immediately by replying to this message and deleting it and all
> copies and backups thereof. Thank you.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l