Re: Copy 100GB MSSQL 9.0 Database to Oracle 10g
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 22 Jun 2010 22:14:27 +0800
Message-ID: <4C20C543.1E71_at_yahoo.com>
if_investor_at_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
Date: Tue, 22 Jun 2010 22:14:27 +0800
Message-ID: <4C20C543.1E71_at_yahoo.com>
if_investor_at_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_mcdonald_at_yahoo.com "Semper in excremento, sole profundum qui variat." ------------------------------------------------------------Received on Tue Jun 22 2010 - 09:14:27 CDT