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

Giganews Newsgroups
Subject: Re: Copy 100GB MSSQL 9.0 Database to Oracle 10g
Posted by:  Connor McDonald (connor_mcdona…@yahoo.com)
Date: Tue, 22 Jun 2010

if_invest…@yahoo.com wrote:
>
> Hi,
>
> I am not sure whether this is the correct group; Perhaps I should
> choose
> an MSSQL one.
>
> Does anybody know of a way to copy a database of about 100GB in size,
> on a Win2003 AMD 64-bit platform, from MSSQL 9.0 to Oracle (Any
> version,
> but hopefully 10g).
>
> Any ideas would be greatly appreciated.
>
> Thanks,
> QZ

check out GoldenGate.  Its desgined for precisely this purpose

--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web:http://www.oracledba.co.uk
web:http://www.oaktable.net
email: connor_mcdona…@yahoo.com

"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------

Replies

None

In response to

Copy 100GB MSSQL 9.0 Database to Oracle 10g posted by if_invest…@yahoo.com on Sun, 13 Jun 2010