I'm looking for a tool/utility to put into my automated scripts for loading a database to a baseline level.
I've seen one before that was capable of creating an original of the data by pulling it from the target DB and then repopulating the DB when the test is run. That one stored the data in XML files.
My environment is C# .NET in VS 2010 and I'm working with unit tests for now. (I know they're not really "unit tests" but they are.)
If you're a slave to your free associations, does it automatically become something else?
Look at your database. Can your database export from a command line, and import as well?
If so, that would likely be easy to script with almost any test automation tool.
Joe StrazzereVisit my website: AllThingsQuality.com to learn more about quality, testing, and QA!
Thanks Joe but I'm looking for something easier and that will work on multiple databases.
I found the one I've heard of before. It's called NDbUnit. The reason I'm looking for something else is because the project hasn't had much activity of late. Maybe it's just that stable.
It's really slick. Fast and pretty easy to use from what I've seen.
Unless someone comes up with a newer tool I'll give that one a try.
Most DBs have some sort of command for a DB dump that'll generate all the SQL commands necessary for rebuilding the database with all the schema and insert operations.
Of course if the devs update the DB, you'll have to apply the dump first, then apply the same DB updates made. Which could be a good as you're also testing the DB update procedure.
SDET / Consultant LinkedIn profile