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

Home -> Community -> Usenet -> c.d.o.server -> Re: MS SQLServer to Oracle data migration - info needed

Re: MS SQLServer to Oracle data migration - info needed

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Wed, 26 Jun 2002 13:39:25 -0500
Message-ID: <1e2khukk5of6ut1gg5pmcc7dlfkih4f6c7@4ax.com>


Not only is this commercial spam, but the site itself indicates that the tool will migrate FROM Oracle TO SqlServer not the other way..
( Is there really a market for down-functioning a database?)

bishehabib_at_yahoo.ca (Bishe) wrote:

>I would highly recommend SQLPorter by Realsoftstudio.com
>
>We have now been using their migration tool for some time now and it
>is just great. Instead of spending hours with the migration procedures
>and debuging the Oracle migration tool or DTS, our migration of all
>tables over 700 and 45 Gig was completed without any errors.
>
>you can see them at www.realsoftstudio.com
>
>Hope this helps
>
>Cyrus
>
>DB developer
>
>
>"Alexys Flores" <arflores1_at_earthlink.net> wrote in message news:<i7HR8.2500$XO2.1726_at_newsread1.prod.itd.earthlink.net>...
>> Its a pain in the butt, first you need to re-engineer your schema in Mickey
>> Soft SQL Server before moving data to Oracle. Check all your Column, Stored
>> Procedures and Table naming convention in which Oracle has a Reserve Name
>> Statement and Constraints, coz this will give you ton's of problem. After
>> you have done those stuff use MickeySoft SQL Server DTS utilities to
>> transfer data to Oracle Instance. Reminder you need to deconstraints table
>> in SQL Server prior to moving data to Oracle Instance Table.
>>
>> prav_saras <member_at_dbforums.com> wrote in message
>> news:3d14157f$1_at_usenetgateway.com...
>> > I have been asked to look at migrating 20Gb of data from a MS SQLServer
>> > system into Oracle 8i. one field is Image in one table of sqlserver Has
>> > anyone else done a SQLServer to Oracle migration, and if so, how?
>> >
>> > Thanks
>> >
>> >
>> >
>> > --
>> > Praveen sharma
>> > Project lead
>> > Jcast networks Ltd.
>> > New Delhi
>> > India
>> >
>> > Posted via dBforums
>> > http://dbforums.com
>> >

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Jun 26 2002 - 13:39:25 CDT

Original text of this message

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