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: Terry Dykstra <dontreply_tddykstra_at_forestoil.ca>
Date: Wed, 26 Jun 2002 19:49:23 GMT
Message-ID: <7VoS8.40215$Aa4.1939032@news0.telusplanet.net>


I looked at the site and I see a version for MSSQLServer(6.5/7/2000) to Oracle listed. So perhaps before giving these answers, check your references a bit more.

--
Terry Dykstra
Canadian Forest Oil Ltd.
"TurkBear" <jgreco1_at_mn.rr.com> wrote in message
news:1e2khukk5of6ut1gg5pmcc7dlfkih4f6c7_at_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 - 14:49:23 CDT

Original text of this message

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