MySQL Forums
Forum List  »  Other Migration

Re: Intersystems Cache To MySQL
Posted by: James Hogan
Date: May 14, 2007 08:18AM

In case it helps the next guy or at least gives some people something to laugh about, I put the code I'm using online at:

http://www.txstock.com/cachetomysql/

Module1.vb and TableProcessor.vb in a VS 2005 project with a reference to ABO/ODBC/MySQL connector sort of kind of works. As I said, I'm dealing with over 500 "tables" which are classes in Cache cause Cache blows hard. You'll also note that I have a "maxthreads" count set to 5 because I have a 5 connection license (also sucks - but then again, you'll see I have code for running multi-threaded or single threaded because multithreaded has its own problems). To convert my 500+ tables and columns, I've had the program running for over 48 hours and it still isn't done. :(

My perl version, that may or may not work is at:
http://www.txstock.com/cachetomysql/perlMoveData.txt

but I might have made some edits since I tried to run it last. Again, the error I was getting was out of memory errors in Win32 - I suspect the problem is a SELECT * FROM TABLE statement where the table has over 180 columns that are all huge varchars. I'd suppose either of these programs would kind of work for most cache systems, but not mine.

My next effort is going to be to create all of the tables using the program I wrote, then try the MySQL migration tool to move the data - because again, the tool can't create the tables properly.

ughck.

Options: ReplyQuote


Subject
Views
Written By
Posted
10481
May 08, 2007 01:18PM
Re: Intersystems Cache To MySQL
5454
May 14, 2007 08:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.