Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to convert SQLSERVER DBS to ORACLE DBs

Re: How to convert SQLSERVER DBS to ORACLE DBs

From: Don Malzahn <dmalzahn_at_harper.cc.il.us>
Date: Fri, 13 Sep 2002 12:53:30 -0800
Message-ID: <F001.004CFE34.20020913125330@fatcity.com>


Justin,

Has anyone heard of a product called dbPal? I did a beta of it and it looked pretty cool. It allows you to take your written application which uses one database, and port the schema over to other databases. It moves the schema, it does versioning, and it deals with SQL Server and I thought Oracle, as well as several other databases (at different release levels). This could also have Data Warehousing uses. It's also quite affordable.

I'd recommend a look at it.

http://dbpal/com

(or the parent company) http://it-map.com

PS Tell Tim, Don sent you!

At 11:08 AM 9/13/02 -0800, you wrote:
>You could also try DTS in SQL Server 2000. That will create the schema
>in Oracle and then move the data to Oracle as well. It is a neat
>utility from Microsoft.
>
>Regards
>
>
>--- Justin Cave <jcave_at_cableone.net> wrote:
> > At 09:03 PM 9/12/2002, you wrote:
> > >Hi
> > >I want to convert SQLSERVER DBs to ORACLE DBs? HOw to convert DBs
> > it?
> > >To import objects I have created one scripts but how to import data
> > into
> > >ORACLE DBs.
> >
> > There's a utility that Oracle puts out called the Oracle Migration
> > Toolkit
> > which does this more or less automagically. You can download it from
> > OTN.
> > Justin Cave
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Justin Cave
> > INET: jcave_at_cableone.net
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> > Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
>=====
>Mohammed Shakir
>CompuSoft, Inc.
>11 Heather Way
>East Brunswick, NJ 08816-2825
>(732) 672-0464 (Cell)
>(732) 257-6001 (Home)
>
>__________________________________________________
>Do you Yahoo!?
>Yahoo! News - Today's headlines
>http://news.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mohammed Shakir
> INET: mshakir08816_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).




Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829 E-mail: dmalzahn@harper.cc.il.us Web page: http://www.harpercollege.edu "The only limit to our realization of tomorrow will be our doubts of today". - FDR
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Malzahn
  INET: dmalzahn_at_harper.cc.il.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Sep 13 2002 - 15:53:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US