Re: best way to export from MSSQL 6.5 to Oracle8?

From: Ciaran <ciaran_at_absolutely.demon.co.uk>
Date: Thu, 22 Apr 1999 22:41:22 GMT
Message-ID: <371fa51e.2901193@news.demon.co.uk>

Joe

The easiest way I've found is using Access to 'Get External Data' from a SQL Server ODBC source and use the Data Migration Wizard for Access to copy 'structure and data' over.

The name of the Access database, i.e. cars.mdb is the user under which the tables will be created and populated.

Cheers,
- Ciaran

On Tue, 20 Apr 1999 15:19:42 -0400, Joe Driscoll <joe_at_newsdigital.com> wrote:

>as the subject asks, what is the best way, tool, program,
>etc... ?
>
>Thanks :)
>
>
>--
>
>Joe Driscoll
>Database / UNIX Systems Administrator
>News Internet Services
>978-551-1153
>joe_at_newsdigital.com
>http://www.newsinternet.com
>
>"Whether you think you can
>or you can't, you're right"
>Henry Ford
Received on Thu Apr 22 1999 - 17:41:22 CDT