thank you for the reply, I have gone through the generated script, some how the RunScript did not fail after creating the tamporary (O_N) tables.
I manually copied the script and ran in it in the console worked. I am trying to migrate to sql server, could you please give me some tips to migrate to sql server (mssql). Thank you, Ram On Wednesday, January 4, 2023 at 12:50:36 AM UTC-8 Evgenij Ryazanov wrote: > Hi! > > Table definition and table data are stored separately and they are > recovered separately too. > > The recovery tool works in the following way (I skipped unrelated steps > for simplicity): > 1. It constructs a temporary table with LOB chunks from all tables first. > 2. Then, it recovers data from tables, it creates a new temporary table > for each found table for that purpose. LOB values for them are constructed > from chunks from (1). Actual table names, column names, data types and > other attributes aren't yet known at that moment. > 3. Next, it tries to recover metadata of database, including definitions > of actual tables. > 4. After that, If metadata of some table was recovered on step (3) and > data for that table was recovered on step (2) data is copied from the > temporary table into actual one. > 5. Finally, all temporary tables are dropped. > > This strategy isn't perfect and can potentially be improved, at least for > some cases when both data and metadata are recoverable. > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/8205720d-46a2-4b0d-a590-bfab00c900bcn%40googlegroups.com.
