Re: PostgreSQL - H2 data migrations
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 h2-datab...@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
PostgreSQL - H2 data migrations
Hello. 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 ? Thanks in advance. -- You received this message because you are subscribed to the Google Groups H2 Database group. To post to this group, send email to h2-datab...@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
Re: PostgreSQL - H2 data migrations
sql-workbench has a reasonable data migration tool that might help: http://www.sql-workbench.net/manual/data-pumper.html http://www.sql-workbench.net/manual/data-pumper.htmlCheers Kerry On Tue, Jun 29, 2010 at 2:07 AM, johnba...@gmail.com johnba...@gmail.comwrote: Hello. 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 ? Thanks in advance. -- You received this message because you are subscribed to the Google Groups H2 Database group. To post to this group, send email to h2-datab...@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.comh2-database%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/h2-database?hl=en. -- You received this message because you are subscribed to the Google Groups H2 Database group. To post to this group, send email to h2-datab...@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.