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
(
API_PROVIDER, API_NAME, API_Venter code hereERSION
)

(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