Hi,
Migrate Oracle to Mysql
-------------------------------------
1)import dump into local oracle windows machine
2)make odbc bridge connection with oracle
3)install mysql and import dump from oracle to mysql using odbc bridge connection
4)select the tables which are all used for HQServer
5)import all tables related to hqserver
6)Install HQserver with mysql
7)we can able to see all the resourcetypes and alerts in HQserver UI
8)but i got some sql errors in server.log
ERROR [main] [org.hyperic.hibernate.id.HQMultipleHiLoPerTableGenerator@163] could not read or init a hi value
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hq.hq_sequence' doesn't exist
ERROR [Timer-2] [org.jboss.ejb.plugins.LogInterceptor@413] RuntimeException in method: public abstract java.util.Map org.hyperic.hq.measurement.shared.DataManagerLocal.getAggregateDataByMetric(java.util.List,long,long,boolean):
org.hyperic.hq.common.SystemException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'maxvalue), count(*) FROM EAM_MEASUREMENT_DATA_1H WHERE timestamp BETWEEN 13998' at line 1
Can any one reply for this above issues
can any one reply how to migrate oracle hqserver data into mysql