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.
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.
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.
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.
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.
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.
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.
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.
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.
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”.
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.
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”.
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
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.
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.