Hi, > I like H2 and want to switch my tests database from postgresql to H2. > Q: How I may make data migration from PostgreSQL to H2 ?
If it's a "one time" operation, then you could use a tool such as "SQuirreL DB Copy Plugin". I haven't used the tool myself but from what I read it should work. There are other tools, see also http://h2database.com/html/links.html Another option is to create "linked tables" within H2 and copy the data from there (using INSERT INTO ... SELECT * FROM LINKED_... or CREATE TABLE ... AS SELECT * FROM LINKED_...). See also http://h2database.com/html/grammar.html#create_linked_table Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
