| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Conversion from SQL Server to Oracle 8
A copy of this was sent to rajeshkg_at_inf.com
(if that email address didn't require changing)
On Sun, 25 Apr 1999 11:58:27 GMT, you wrote:
>Hi,
>
>Can anybody help me in giving some information about tools which can be used
>to migrate MS SQL Server Database to Oracle. The database is around 0.5 G. I
>have one tool but the thing is, it creates columns in lower case in the
>database and I have to access them using quotes i.e. within " ". Also some of
>the SQL columns have default values associated with them. How do I get a
>corresponding match.
>
>Another alternative would be to get Oracle DDL's from SQL Server database..
>
>Any pointers would be of tremendous help. Please respond to my id at
>rajeshkg_at_inf.com. This is very urgent.
>
>Regards
>Rajesh Krishna
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
There are 'conversion' kits freely available. These point out some of the pitfalls and workarounds with the conversions and also provide utilities to automate portions of it. They are a good tool to have in your toolbox (as long as you don't expect them to do 100% of the work that is...) To get them, you need an account on technet -- thats free, just goto http://technet.oracle.com/ and get an account. Once you have an account, goto http://technet.oracle.com/ -> "Find" and search for:
conversion kits
you'll see them all there.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |