Where can I get information on setting up relationships using the h2 console? Is their another front end to use for this?
Using the H2 DB
What do you mean, "setting up relationships?" You can run ALTER TABLE statements either through the SQL Console or through the h2-web-console script described here: http://help.infiniteautomation.com/support/solutions/articles/14000022661-about-the-h2-database
H2 has lots of documentation: http://www.h2database.com/html/main.html
You can also convert to MySQL if you have a greater familiarity with it or tools based upon it.
I am trying to connect to the h2 server DB with "Razorsql" ,but it tells me ------
((ERROR: An error occurred while trying to make a connection to the
JDBC URL: jdbc:h2:P:\IT Dept Installs\Mango Automation 2.7.10
Database may be already in use: "Locked by another process".
Possible solutions: close all other connection(s); use the server
mode [90020-166] ))
Has any one used razor for the h2 DB? Any help would be great. Thanks