Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MS SQLServer to Oracle data migration - info needed
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
>
Received on Mon Jun 24 2002 - 10:44:14 CDT