Want to export a ton of tables, but only get SOME of the records?
Want to apply a GLOBAL filter across the tables to only get the records you want?
Tools > Database Export.
I’m going to export data, NOT DDL.
I’m going to write it to a single JSON file.
I’m going to grab data from a couple of tables.
I ONLY want records from those tables where the CUSTOMER ID is in a specific range.
Note the bottom box – that’s a WHERE clause predicate I can have added to EVERY SELECT * from query we use to get the data to export the tables.
I can also see what this data will look like to see if my filters are correct.
EXISTS (SELECT id FROM IDS WHERE cust_id = id)
Note you can do row-counts and sorts to make sure the data is JUST right before you export it.
Export, and then you get your data.