Mysql to oracle migration

Hi,

I am trying to migrate mysql to oracle to have full text search.
I updated successfully a RT 3.6.10 to RT 4.0.5 using mysql. However, when I
migrate data and objects to oracle using sql developer, there is some
issues in the attachments encoding, for instance.

Does anyone has migrated from mysql to oracle?

Cheers,
Pedro.

Looks like it’s also supported with pgsql :

if that’s an option for you …On Tue, Apr 10, 2012 at 11:03 AM, Pedro Albuquerque pedroalb@gmail.com wrote:

Hi,

I am trying to migrate mysql to oracle to have full text search.
I updated successfully a RT 3.6.10 to RT 4.0.5 using mysql. However, when I
migrate data and objects to oracle using sql developer, there is some issues
in the attachments encoding, for instance.

Does anyone has migrated from mysql to oracle?

Cheers,
Pedro.

see this thread
Carbon60: Managed Cloud Services Tue, Apr 10, 2012 at 11:06 AM, Sabuj Pattanayek sabujp@gmail.com wrote:

Looks like it’s also supported with pgsql :

What's New in 4: Fast full-text searching — Best Practical Solutions

if that’s an option for you …

On Tue, Apr 10, 2012 at 11:03 AM, Pedro Albuquerque pedroalb@gmail.com wrote:

Hi,

I am trying to migrate mysql to oracle to have full text search.
I updated successfully a RT 3.6.10 to RT 4.0.5 using mysql. However, when I
migrate data and objects to oracle using sql developer, there is some issues
in the attachments encoding, for instance.

Does anyone has migrated from mysql to oracle?

Cheers,
Pedro.

Hi,

I am trying to migrate mysql to oracle to have full text search.
I updated successfully a RT 3.6.10 to RT 4.0.5 using mysql. However, when I
migrate data and objects to oracle using sql developer, there is some
issues in the attachments encoding, for instance.

Does anyone has migrated from mysql to oracle?

Cheers,
Pedro.

You may want to take a look at some of the MySQL->PostgreSQL scripts to
see how they handle attachments. I believe that Oracle would be very
similar.

Regards,
Ken

Thanks for the info.
I will take a look at these scripts and try to use them in Oracle.

I’ll get back to you with updates.

Cheers,
Pedro.On Tue, Apr 10, 2012 at 5:08 PM, Sabuj Pattanayek sabujp@gmail.com wrote:

see this thread

Carbon60: Managed Cloud Services

On Tue, Apr 10, 2012 at 11:06 AM, Sabuj Pattanayek sabujp@gmail.com wrote:

Looks like it’s also supported with pgsql :

What's New in 4: Fast full-text searching — Best Practical Solutions

if that’s an option for you …

On Tue, Apr 10, 2012 at 11:03 AM, Pedro Albuquerque pedroalb@gmail.com wrote:

Hi,

I am trying to migrate mysql to oracle to have full text search.
I updated successfully a RT 3.6.10 to RT 4.0.5 using mysql. However,
when I
migrate data and objects to oracle using sql developer, there is some
issues
in the attachments encoding, for instance.

Does anyone has migrated from mysql to oracle?

Cheers,
Pedro.

Hi,

I took a look at the PostgreSQL scripts but they fail, for instance, when
migrating the attachments. Encoding is base64 in Oracle and other errors
occur.
I am wondering why RT mentions it is possible to migrate using Oracle SQL
developer if it does not work? Does anybody successfully migrated RT from
MySQL to Oracle?

Cheers,
Pedro.

Pedro Albuquerque-3 wrote:

Thanks for the info.
I will take a look at these scripts and try to use them in Oracle.

I’ll get back to you with updates.

Cheers,
Pedro.

Pedro Albuquerque-3 wrote:

Hi,

I am trying to migrate mysql to oracle to have full text search.
I updated successfully a RT 3.6.10 to RT 4.0.5 using mysql. However, when
I
migrate data and objects to oracle using sql developer, there is some
issues in the attachments encoding, for instance.

Does anyone has migrated from mysql to oracle?

Cheers,
Pedro.

View this message in context: http://old.nabble.com/mysql-to-oracle-migration-tp33662526p33763376.html

I am wondering why RT mentions it is possible to migrate using Oracle SQL
developer if it does not work? Does anybody successfully migrated RT from
MySQL to Oracle?

Where does RT say that? I’d love to correct it, since I would never
expect it to work.

-kevin

Hi Kevin,

Since this is written here,
http://requesttracker.wikia.com/wiki/MySQLToOracle, I thought it would
work in some way.

Cheers,
Pedro.On 02/05/2012 15:10, Kevin Falcone wrote:

On Wed, May 02, 2012 at 06:59:21AM -0700, pedroalb wrote:

I am wondering why RT mentions it is possible to migrate using Oracle SQL
developer if it does not work? Does anybody successfully migrated RT from
MySQL to Oracle?

Where does RT say that? I’d love to correct it, since I would never
expect it to work.

-kevin

I am wondering why RT mentions it is possible to migrate using Oracle SQL
developer if it does not work? Does anybody successfully migrated RT from
MySQL to Oracle?
Where does RT say that? I’d love to correct it, since I would never
expect it to work.

Since this is written here,
http://requesttracker.wikia.com/wiki/MySQLToOracle, I thought it
would work in some way.

Ah, that’s a user contributed wiki page. I thought you meant it was
written in the official documentation. You’d need to find the author of
that page to know more. It might be worth editing the page to indicate
that it doesn’t always “just work”.

-kevin

Sorry about this confusion. I’ll wait for Scott since he already done this.

Cheers,
Pedro.On 02/05/2012 16:16, Kevin Falcone wrote:

On Wed, May 02, 2012 at 03:13:58PM +0100, Pedro Albuquerque wrote:

On 02/05/2012 15:10, Kevin Falcone wrote:

On Wed, May 02, 2012 at 06:59:21AM -0700, pedroalb wrote:

I am wondering why RT mentions it is possible to migrate using Oracle SQL
developer if it does not work? Does anybody successfully migrated RT from
MySQL to Oracle?

Where does RT say that? I’d love to correct it, since I would never
expect it to work.

Since this is written here,
http://requesttracker.wikia.com/wiki/MySQLToOracle, I thought it
would work in some way.

Ah, that’s a user contributed wiki page. I thought you meant it was
written in the official documentation. You’d need to find the author of
that page to know more. It might be worth editing the page to indicate
that it doesn’t always “just work”.

-kevin

Hi Scott,

I successfully migrated from MySQL to Oracle thanks to your script!
I don’t know who wrote the script originally , but big thanks to them.

I just had to make some minor changes but that was it.
Regarding the sequences, I had to create a PL/SQL procedure to update
the sequences.currval to have the max id for each table.
Yes, forgot to mention that one.

Many thanks for your help :slight_smile:
You’re welcome, glad it went smooth. Best advice is not to use the
migration tool in SQLDeveloper, we
burnt a lot of time trying to get that to work. We should add the
sequence update to the code
and post it to the wiki.

Hi,

I will post the PL/SQL code to the wiki.

Cheers,
Pedro.On 04/05/2012 17:33, Scott wrote:

You’re welcome, glad it went smooth. Best advice is not to use the
migration tool in SQLDeveloper, we
burnt a lot of time trying to get that to work. We should add the
sequence update to the code
and post it to the wiki.