1 person found this helpful
This isn't really an APEX specific question, you might get better feedback in the SQL forum.
I think SQL Developer may even have a tool to aid with this.
Ah that makes sense!
Although... I don't have access to the database on the backend, only through the SQL Commands page within the APEX workspace. So I assume this means I'm limited to doing SQL commands, and can't use something like SQL Developer. Perhaps a script could be written to do what I'm asking? (again, not something I have a lot of experience with so any input would be appreciated).
That is particularly limiting - whatever you do you'll need to be able to create database links so you can run queries across environments.
No doubt there are dozens of scripts out there already to help you out. Check your privileges first.