Having just experienced a week of extreme headaches and bad luck I thought it would be a good idea to rather reflect on the one huge positive that came out of it, the get out of jail free card I received. Throughout the week I had been experiencing some really painful random database issues that just made no sense, if your interested you can read more about the issue here http://www.nabble.com/Quartz-%2B-GORM-%2B-MySQL-gives-random-pain!-td24089307.html#a24089307.
The work around for this problem was to use PostgreSQL instead of MySQL. So I had to migrate my production database to reflect this change in all of my environments, oh dear...
Not to worry, YouTube had the answer! I found this video through a random Google search.
This DB migration application can be found on the EnterpriseDB download page. When you download this application you will actually be downloading the Java source code for it. After downloading the code I just imported it into my NetBeans IDE by creating a new project from existing sources. Then I simply ran the application from within my IDE and it all just worked!!! What a relief.
Download "MySQL to Postgres Migration Wizard by EnterpriseDB v1.1" http://www.enterprisedb.com/products/download.do
Twitter Updates
Wednesday, June 24, 2009
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment