Re: Converting MS-SQL schema file to Oracle schema file

I think this is the best way dick.

U can use Access as an interface, as I have used that .

Donno abt the benchmark software provided by oracle.

U need to see the Datatypes if CLOB n BLOB is used.

• Chirag Majmundar

On Wed, 29 Sep 2004 12:23:52 -0400, Goulet, Dick <dgoulet_at_vicr.com> wrote:
> Normally one uses ODBC to push the tables & data from Access to Oracle. =
> But I highly recommend NOT doing that. Access will create it's objects =
> in a case sensitive and non ANSI standard way. Create the tables =
> manually & then push the data in by linking the new tables.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
>
>
> -----Original Message-----
> From: Birkir Bjornsson [mailto:birkir_at_teymi.is]
> Sent: Wednesday, September 29, 2004 12:16 PM
> To: oracle-l_at_freelists.org
> Subject: Converting MS-SQL schema file to Oracle schema file
>
> =3D=20
> Hi=20
>
> =20
>
> I was asked to convert an MS SQL Schema file to an Oracl=3D e =
> Schemafile. Does
> anyone of you know of a tool to do it or shall I do it by hand?=20
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>

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