You’ve just spent hours writing the SQL that will rule the world. Now, how are you going to test it?
It’s not always practical (or permitted) to subset it from your production data, and it’s not a good use of your time to create thousands of rows yourself. What’s the best way to get your hands on a dataset you can test with?
We designed the Data Generator function in Toad for Oracle Xpert Edition for just this use case.
- Select a table in the Schema Browser and request as many rows of data in it as you need for meaningful testing.
- Specify the type and format of data (name, address, date, etc.) you want for each column in the table.
- For relational data, use Master-Detail Browser to check the referential integrity of your generated data to other tables.
Click on this 3-minute video to watch our John Pocknell walk you through the UI in Toad Xpert Edition and demonstrate how quickly you can go from writing code to testing it:
Data Generator runs inside your Toad for Oracle environment – no need to run it separately.
You could spend hours cobbling together your own test data, then more hours modifying it when the schema changes. Or, you could spend a few seconds generating a dataset as large and as relational as you need and change it as often as you like.
This is part 1 of my 5-part video series designed to help you decide whether Toad for Oracle Xpert Edition is right for you. If you test a lot of SQL and need to generate data for it, then Data Generator and Master-Detail Browser are pretty strong arguments. For more details, have a look at Reason #4 in “Five Ways Toad Xpert Edition Can Help You Write Better Code,” our updated technical brief.
In fact, if you’re ready to dig in, download a 30-day trial and take Toad Xpert Edition for a test drive. Let me know in the comments below how much data you’re able to generate in a month.