<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
On 05/04/2012 08:14 AM, Pedro Albuquerque wrote:
<blockquote cite="mid:4FA3D61C.30000@ebi.ac.uk" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<font face="Courier New">Hi Scott,<br>
<br>
I successfully migrated from MySQL to Oracle thanks to your
script!</font></blockquote>
I don't know who wrote the script originally , but big thanks to
them. <br>
<br>
<blockquote cite="mid:4FA3D61C.30000@ebi.ac.uk" type="cite"><font
face="Courier New"> I
just had to make some minor changes but that was it.<br>
Regarding the sequences, I had to create a PL/SQL procedure to
update
the sequences.currval to have the max id for each table.<br>
</font></blockquote>
Yes, forgot to mention that one. <br>
<blockquote cite="mid:4FA3D61C.30000@ebi.ac.uk" type="cite"><font
face="Courier New">
<br>
Many thanks for your help :)<br>
</font></blockquote>
You're welcome, glad it went smooth. Best advice is not to use the
migration tool in SQLDeveloper, we <br>
burnt a lot of time trying to get that to work. We should add the
sequence update to the code<br>
and post it to the wiki.<br>
<br>
<blockquote cite="mid:4FA3D61C.30000@ebi.ac.uk" type="cite"><font
face="Courier New">
<br>
Cheers,<br>
Pedro.<br>
</font><br>
On 03/05/2012 15:04, Pedro Albuquerque wrote:
<blockquote cite="mid:4FA29070.7030206@ebi.ac.uk" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<font face="Courier New">Hi Scott,<br>
<br>
Many thanks for the script and explanation.<br>
I will take a look at this and will get back to you.<br>
<br>
Cheers,<br>
Pedro.<br>
</font><br>
On 02/05/2012 23:16, Scott wrote:
<blockquote cite="mid:4FA1B243.9070000@gmail.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
We did this awhile ago, so my memory may be a little fuzzy.
First off
forget the SQLDeveloper migration, <br>
it mostly works but you have to work around some issues. Our
biggest
issue was that mysql defaults to <br>
utf8 and our Oracle DB's are not utf8, so some of the stored
documents
(mostly word) have don't totally <br>
display right. I thinks its just the apostrophes, quotes,
...etc.
Another issue is that RT doesn't like to <br>
use blobs in PostgreSQL & Oracle, so they base64 encode
binary
objects and store them in clobs. Like <br>
I said earlier I just modified the PostgreSQL migration
script. I've
attached the script, you probably don't<br>
need the NLS_LANG env setting or you may not want my
NLS_DATE_FORMAT
setting. I really didn't change <br>
much. I did add a new table list, just commented out the old
one. So
after all our messing around with<br>
the SQLDeveloper migration tool, we had success by using the
Oracle
table create sql that comes with <br>
the RT dist and running the attached script. As I said I may
be
forgetting a step, but give it a whirl. If <br>
you have questions, I will do my best to answer.<br>
<br>
Scott <br>
<br>
<br>
On 05/02/2012 10:15 AM, Pedro Albuquerque wrote:
<blockquote cite="mid:4FA14FA7.6090006@ebi.ac.uk" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
<font face="Courier New">Many thanks Scott.<br>
Looking forward to hearing from you.<br>
<br>
Cheers,<br>
Pedro.<br>
</font><br>
On 02/05/2012 16:14, Scott wrote:
<blockquote cite="mid:4FA14F43.302@gmail.com" type="cite">I
have
done it, let me gather what we did and I will it to you. <br>
I think I used the postgresql script and just modified
it. Sorry I'm <br>
swamped right now, but I will get back to you later today.
<br>
<br>
<br>
n 05/02/2012 08:59 AM, pedroalb wrote: <br>
<blockquote type="cite">Hi, <br>
<br>
I took a look at the PostgreSQL scripts but they fail,
for instance,
when <br>
migrating the attachments. Encoding is base64 in Oracle
and other
errors <br>
occur. <br>
I am wondering why RT mentions it is possible to migrate
using Oracle
SQL <br>
developer if it does not work? Does anybody successfully
migrated RT
from <br>
MySQL to Oracle? <br>
<br>
Cheers, <br>
Pedro. <br>
<br>
<br>
<br>
Pedro Albuquerque-3 wrote: <br>
<blockquote type="cite">
<blockquote type="cite">Thanks for the info. <br>
I will take a look at these scripts and try to use
them in Oracle. <br>
<br>
I'll get back to you with updates. <br>
<br>
Cheers, <br>
Pedro. <br>
</blockquote>
</blockquote>
<br>
Pedro Albuquerque-3 wrote: <br>
<blockquote type="cite">Hi, <br>
<br>
I am trying to migrate mysql to oracle to have full
text search. <br>
I updated successfully a RT 3.6.10 to RT 4.0.5 using
mysql. However,
when <br>
I <br>
migrate data and objects to oracle using sql
developer, there is some <br>
issues in the attachments encoding, for instance. <br>
<br>
Does anyone has migrated from mysql to oracle? <br>
<br>
Cheers, <br>
Pedro. <br>
<br>
<br>
</blockquote>
</blockquote>
<br>
</blockquote>
</blockquote>
<br>
</blockquote>
</blockquote>
</blockquote>
<br>
</body>
</html>