Using the scott-tiger sample, I notice that a base table had to be specified, and that relationships had to exist. Assuming there is no filter (or Where), you could get a max of 44 records with DEPARTMENT as base table, but only 43 with EMPLOYEE as base table.
For my case, I have a DB where some tables have relationships, and others don't (even though they should be related, but aren't and can't be refactored because of necessary approvals from architects / managers). So, what I'd like is for Jailer to read the database, and dump all records (as DBUnit XML), following the heirarchy/dependencies, but at the same time also including those records that have no dependencies / relationships. Would that be possible?
At the worst case, I'd just break all the associations, and dump each table manually (which seems like a lot of work).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
open the "Data Model Editor", select and "Edit" the table you want to dump all records from and check the "always export all rows (initial data)" checkbox.
Hth,
Ralf
Last edit: Ralf Wisser 2016-07-08
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Using the scott-tiger sample, I notice that a base table had to be specified, and that relationships had to exist. Assuming there is no filter (or Where), you could get a max of 44 records with DEPARTMENT as base table, but only 43 with EMPLOYEE as base table.
For my case, I have a DB where some tables have relationships, and others don't (even though they should be related, but aren't and can't be refactored because of necessary approvals from architects / managers). So, what I'd like is for Jailer to read the database, and dump all records (as DBUnit XML), following the heirarchy/dependencies, but at the same time also including those records that have no dependencies / relationships. Would that be possible?
At the worst case, I'd just break all the associations, and dump each table manually (which seems like a lot of work).
Hi,
open the "Data Model Editor", select and "Edit" the table you want to dump all records from and check the "always export all rows (initial data)" checkbox.
Hth,
Ralf
Last edit: Ralf Wisser 2016-07-08