Re: Aaagh! Migration from >spit< SQL server to >hurray< ORACLE?
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 31 Jan 2001 16:02:43 -0000
Message-ID: <959cv5$1p5$1_at_soap.pipex.net>
Date: Wed, 31 Jan 2001 16:02:43 -0000
Message-ID: <959cv5$1p5$1_at_soap.pipex.net>
Version 8i (at least from 8.1.6 which is the first to go with0 comes with a handy dandy migration tool which will migrate the database from sql server to oracle. This would be a good first shot.
regards
-- Niall Litchfield Oracle DBA Audit Commission UK "Chris Schnurr" <chrisDOT.schnurr_at_iontasDOT.com> wrote in message news:3a78123a.14899103_at_news.tinet.ie...Received on Wed Jan 31 2001 - 17:02:43 CET
> Hi All,
>
> We have an application that currently runs on a SQL server database.
>
> I have a nice larg script that I want to use to generate an equivalent
> database on Oracle (ver 8i).
>
> How do I create the database ? Do I have to add each field and each
> table by hand or are there utilities out there to create the database
> for me from the script?
>
> Or, is there a way of importing an ODBC datasource direct into Oracle?
>
> And finally, this must be a frequently Asked Question, where are the
> others kept?
>
> Many thanks,
>
> chris
>
> chris_dot_schnurr_at_iontas_dot_com
> (replace the _dot_s to email, although I lurk here regularly)
>