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@xxxxxxxx> 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@xxxxxxxx]
> Sent: Wednesday, September 29, 2004 12:16 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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

Other related posts: