Re: Migration Project: MSSQL to Oracle
Date: Sun, 11 May 2014 20:32:45 -0600
Message-ID: <537032CD.30806_at_evdbt.com>
For the purposes of a migration, using the ODBC gateway for read-only purposes, the Gateway for ODBC should be sufficient, as well as no extra cost.
On 5/11/2014 8:03 PM, Bobby Curtis - ACE wrote:
>
> Hans,
>
> The gateway for SQL Server is not free, that stinks! Now the question
> is, will the utilization of a gateway be picked up in the database
> under DBA_FEATURE_USAGE (something like that) view. I know that
> Oracle has started using the feature usage views to track how many
> times a feature is used. If it is tracked, then gateways cannot be
> used to solve the problem of a free migration tool. Does anyone know
> if the migration workbench is free? I found this related to migrating
> SQL Server with the migration workbench in SQL Developer
> (http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm);
> however, it doesn't show a cost, if any, for the workbench.
>
> -Bobby
>
> *From:*oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Hans Forbrich
> *Sent:* Sunday, May 11, 2014 9:45 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: Migration Project: MSSQL to Oracle
>
> Based on experience and verified by
> http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf,
> Oracle's price list, the "Transparent Gateways" are licensed and have
> a price tag.
>
> The Heterogeneous Services (Formerly Transparent Gateway for OBDC, and
> now Database Gateway for ODBC) is included in the DB license according
> to
> http://docs.oracle.com/cd/E16655_01/license.121/e17614/editions.htm#DBLIC125
> and
> http://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC123
>
>
> Decent information on config and use at
> http://docs.oracle.com/cd/E16655_01/server.121/e17907/toc.htm (Oracle®
> Database Heterogeneous Connectivity User's Guide for 12c Release 1 (12.1))
>
> That, plus a set of good scripts (in PL/SQL) can go a long way to
> helping the OP, if he's interested in learning about it.
>
> /Hans
>
> On 11/05/2014 5:30 PM, Tim Gorman wrote:
>
> Oracle Gateway for SQL Server is a standard part of Oracle
> Database, downloaded as one of the seven download files.Â
> Installation and deployment is quite easy, and I don't believe
> there is any additional license cost;Â of course you'll want to
> check that to be certain.
>
> The gateway allows you to query tables in SQL Server over Oracle
> database links.
>
>
>
> On 5/11/2014 4:59 PM, Nik Tek wrote:
>
> Hi Bobby,
>
> I'm not familiar with Oracle GoldenGate, and I'm not sure it
> is free to use it.
>
> The requirement is tool should be completely free.
>
> Thank you
>
> Raju
>
> On Sun, May 11, 2014 at 1:35 PM, Bobby Curtis - ACE
> <curtisbl_at_gmail.com <mailto:curtisbl_at_gmail.com>> wrote:
>
> Are you looking to write a tool to do the migration? Are
> you prohibited from using Oracle GoldenGate? There are
> tools that are designed to this already, please explain in
> more detail why you want to write a new tool.
>
> Â
>
> Thanks
>
> Â
>
> Bobby
>
> Â
>
> *From:*oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>
> [mailto:oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>] *On Behalf Of *Nik Tek
> *Sent:* Sunday, May 11, 2014 4:16 PM
> *To:* ORACLE-L
> *Subject:* Migration Project: MSSQL to Oracle
>
> Â
>
> Hi,
>
> Â
>
> I have a question about migrating data from MSSQL and Oracle.
>
> Â
>
> I'm working on a migration project from MSSQL and Oracle.
>
> Â
>
> I have around 1040 tables on source (MSSQL) side, database
> size could be around 100-300 GB.
>
> Â
>
> I would have to do this operation repeatedly, so I'm
> thinking of creating it as a tool (command line based).
>
> Â
>
> Could anyone give me some guidelines on how to achieve it.
>
> Â
>
> * I have already created the destination schema on
> Oracle(Converted all SPs, Triggers, Tables, Views,
> Functions to pl/sql compatibility). I have to migrate data
> ONLY between source and destination databases.
>
> Â
>
> Source: MS SQL 2008 R2
>
> Destination: Oracle11g R2
>
> Â
>
> I have used Oracle's SQL Developer Migration Tool, but I'm
> not sure if I can bundle it as part of my software, as
> this tool is going to be free to the community.
>
> Â
>
> Thank you
>
> NikTekki
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 12 2014 - 04:32:45 CEST