Scripts generated by this tool aren't really suitable for data migration. It will be better to use the SCRIPT <https://h2database.com/html/commands.html#script> command or the Script tool to produce an SQL without all this messy temporary tables and edit their resulting script as necessary. They also can be used to export different tables separately.
Unfortunately, different database systems aren't really compatible with each other even in their basic functionality, so usually you cannot execute an SQL dump from one database system in another database system without some modifications, such as replacements of data types and other. There are some third-party tools for such migrations, but usually they support only few database systems and I don't know whether some of them supports migrations from H2 to MS SQL or not. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/2ec41a0a-b297-4d62-becd-2b4cac94cc38n%40googlegroups.com.
