</code> http://technet.oracle.com/software/tech/migration/workbench/software_index.htm <code>

needs to be updated.

Tom, someone tells to my developer team that he won't use a Oracle database to share our data at the web because it is not secure to his web site and there are lot vulnerabilities around Oracle database. He said that we have to develop the web application using mySQL to sharing our data from a Oracle9iR2 database. This sound to me like an authority question, this man do the same in her company, they use Oracle database with their client application an user mySQL to show information at the web site.

We need about three tables on that database, I proposed to use Oracle Streams to propagate the tables from production to the database to share the data on the web but the web application was developed using mySQL.

I want to change his mind, and know the mind of my developer team (ease) but this man appears to had a bad experience with Oracle some time ago.

What do I have to do? Maybe, don’t care about, learn something of mySQL. One of the developers tell me why we must change mySQL to Oracle, if it is secure, it is replicated by a java application from Oracle database, and web sites like Google.com, Nasa.gov, Yahoo.com and Amazon.com use mySQL?

How many security related features does mySQL have?

Your questions and links will help me, thanks

I have a coworker telling everybody in the office that we should do away with Oracle because of the licensing cost and that MySQL can do anything that Oracle can do and better. Do you know anything about MySQL so you can make an informed comparison?

"MySQL can do anything that Oracle can do and better."

Man oh man, I wouldn't know where to begin... Speaking very roughly, last year's version of MySQL caught up with Oracle version 7 (1992). That is, they finally implemented stored procedures and triggers. I think they got around to foreign keys not much earlier (which I believe Oracle has had since version 7, also).

Take it from a guy who doesn't work for Oracle and has worked with MySQL, PostgreSQL and Oracle. The company I work for is using PostgreSQL exclusively these days. MySQL didn't come close to meeting our requirements. However I'm far from happy with PostgreSQL - see my complaints here - </code> http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:1886476148373#67219028766976

and here - 

http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:4685088047969#68344902112056 <code>

In other words, IMO, Oracle > PostgreSQL > MySQL, and I find PostgreSQL to be too wimpy. But it all depends on your requirements obviously.

Berkeley DB and InnoDB underly many of the capabilities of mySQL.

TOm:

you refer to xe above as an alternative to mySQL. Does this provide all features and better than mySQL and there is no database size limitations.

Hi Tom

Oracle has acquired Sun and hence the "mySQL" database. ( For 3-Tier architecture, I heard that mySQL is better than Oracle. Is it the reason that Oracle has acquired Sun? :) What would be the future of the free, open-sourced database ( or the Oracle Database itself :) ?

I would like to access Mysql from Oracle .
As I understand , there is no transparent gateway for mysql .

How can I access mysql from Oracle .

Thanks

Sorry . I did not spell out my environment correctly .

I am on 11g R1 on windows 64 bit. Unfortunately , there is no 64 bit odbc for this ( as far as I know ) . What is the workaround ?


Thank you.

I was looking at Note.466225.1.

May be I misunderstood .

In any case , I went in , tried the ODBC setup . I could not get connected to the mysql db from oracle .

listener.ora
==============

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = sqltest)
      (PROGRAM = dg4odbc)
      (SID_NAME = sqltest)
      (ORACLE_HOME = D:\app\Root\product\11.1.0\db_1)
    )
  )

tnsnames.ora
============

sqltest  =
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=mfz-db01)(PORT=1521))
    (CONNECT_DATA=(SID=sqltest))
    (HS=OK)
  )

Pinging the database
-----------------------

C:\>tnsping sqltest

TNS Ping Utility for 64-bit Windows: Version 11.1.0.7.0 - Production on 08-DEC-2009 09:32:03

Copyright (c) 1997, 2008, Oracle.  All rights reserved.

Used parameter files:
D:\app\Root\product\11.1.0\db_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=mfz-db01)(PORT=1521)) (CONNECT_DATA=
(SID=sqltest)) (HS=OK))
OK (70 msec)
  
 

Created the db link
---------------------

CREATE PUBLIC DATABASE LINK MYSQLDB CONNECT TO SQLTEST IDENTIFIED BY userid USING 'pwd'; 

SQL> select * from dual@mysqldb;
select * from dual@mysqldb
                   *
ERROR at line 1:
ORA-12154: TNS:could not resolve the connect identifier specified

What am I doing wrong ? Please advise.

I am checking the connectivity only from the server machine .the tnsnames.ora posted above is from the server

tnsnames.ora
============


sqltest =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=mfz-db01)(PORT=1521))
(CONNECT_DATA=(SID=sqltest))
(HS=OK)
)

ops$tkyte%ORA11GR2> create database link ora11gr2@loopback
  2  connect to ops$tkyte
  3  identified by foobar
  4  using 'ora11gr2'
  5  /

Database link created.

ops$tkyte%ORA11GR2> select * from dual@ora11gr2;

D
-
X

Tom,

We have a set of tables in SQLServer along with the data. We have also created a same set of tables in oracle server keeping the same table structure as in SQLServer. Here we need to migrate the data from SQLServer to Oracle and this would be a only one time activity. Hence we decided to use the DG4ODBC gateway to achieve the same. We have configured the settings as indicated in the DG4ODBC setup guide.

However we are facing following issues with the DG4ODBC heterogeneous services:
1) For most of the tables it extracts the data from SQLServer and however for some tables it gives an error message called:
[Micrsoft][SQL native client]Connection is busy with results for another command

2) If we use a cursor on SQLServer table we will get the following error:
ORA-01002: fetch out of sequence

Kindly suggest me whether am I missing any configuration settings or is it a bug?

Also let me know are there any other ways can I import the data into Oracle from SQLServer?


Note: 1) Few tables has image (BLOB) and text (CLOB) columns
2) I have also tried and failed to import the data through MS Access due to LOB columns
3) Also tried and failed to import the csv files using SQLLDR due to LOB columns

Thanks in Advance


Warm Regards
Shiva

Hello,

Now MySQL is supported by Oracle. I have read about MariaDB that works with the same set of binaries that MySQL use. From technical point of view, are there any difference between MariaDB and MySQL?

Thanks,

Oracle migration Workbench claims to migrate MySQL to Oracle.

However, a DATED version of documentation also states that it does not migrate the views, procs etc into Oracle.

http://www.oracle.com/technetwork/developer-tools/sql-developer/supportedmigplatforms-086703.html



Is there a way to automate this migration too?

Greetings!

We need to copy 20 tables from MySQL database to oracle 11g with data for migration purposes.

Could you please suggest the migration methods available to perform this data migration ?


Thank you

There was a typo, target oracle database is on 19c (19.11.0.0).