Re: Copy 100GB MSSQL 9.0 Database to Oracle 10g

Thanks for the replies. Some people asked me for more details about the
issue.

There is an MSSQL 9.00 database about 100GB in size that we need to get a copy of; To be more accurate, we need to get hold of its major schema, and create an Oracle database (Hoping that it will be 10g) with
the same schem, having the same data. (The entire database consists of only
 that schema and whatever the default MSSQL schemas are).

I am not sure if the source DB has unique MSSQL features; I don't know MSSQL, and I am not sure sure what to check.

Thanks,
QZ
On Jun 13, 5:14 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Sun, 13 Jun 2010 20:51:44 +0000, Terry Dykstra wrote:
> > You can use InfoMaker (Sybase).  It has a so called pipeline utility
> > which allws you to move data between ant 2 databases.  Very easy to use.
>
> > Terry Dykstra
>
> My favorite utility for complex cases is still Perl although I am reading
> a Python book and I like what I read. If only there was a comprehensive
> Python archive network, with tons of modules and applications available,
> Python would immediately take over the world by storm. PyPI is not nearly
> as good - yet.
>
> --http://mgogala.byethost5.com
Received on Sun Jun 13 2010 - 23:20:59 CDT