RE: Migration Project: MSSQL to Oracle
- From: "Bobby Curtis - ACE" <curtisbl@xxxxxxxxx>
- To: <fuzzy.graybeard@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 11 May 2014 22:03:10 -0400
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_m
igration/mssqlserver/migrate_microsoft_sqlserver_otn.htm); however, it
doesnt show a cost, if any, for the workbench.
-Bobby
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Hans Forbrich
Sent: Sunday, May 11, 2014 9:45 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx
<mailto:curtisbl@xxxxxxxxx> > 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@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
] 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
Other related posts:
