Hi, > 1)Can the data and the tables in the files be viewed using any sql > client(squirrel viewer) ?
Yes, this should work. > 2)Can I export the data in the file such that it can be imported into > another db? Yes and no. The SQL script generated using the SCRIPT command or Script tool is 'lossless' meaning it contains all data that is meaningful to H2. However, depending on the features you used, such script will not always work on other databases. It's probably easier to use a database copy tool such as the "SQuirreL DB Copy Plugin" at http://dbcopyplugin.sf.net/ - see also the links at http://h2database.com/html/links.html 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.
