migrate existing h2 db to mysql in WSO2APIM 1.8.0

To convert h2 database to Mysql I used SQuirreL DB Copy Plugin .
while copying the h2 database tables to the Mysql database it gives following error.
it is Primary key use in h2 db and this constraint cannot convert to Mysql.

2015-05-18 10:24:43,590 [DBCopy Executor Thread] ERROR net.sourceforge.squirrel_sql.plugins.dbcopy.CopyProgressMonitor – SQL Error code = 1170 sql = CREATE UNIQUE INDEX CONSTRAINT_INDEX_73 ON AM_API

(Bind variable values: WSO2 Identity Server)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column ‘API_PROVIDER’ used in key specification without a key length

appreciate help to fix this issue

Source: mysql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.