EntropyZero Blogging Server

Hi,

I use DataFresh on my Unittests and it's really great but there are a few things that bother me:

- after all the testruns there is always a table df_ChangeTracking left, is there a way to make sure that dataFresh also drops this table after all the unittests so that everything is exactly the same as before the unittests, just a database with all the tables, views, sprocs, ... but no records?

- now, we run the unittests with the sa account in the connectionstring, I prefer to run the unit tests with the db_owner account of the database on which the unit tests run.  Which rights do I have to give the db_owner account to make sure that dataFresh is able to run?

Thanks,
Kind regards,
Bert Janssens

Hi Bert -

 Thanks for the question. If you make a call to the RemoveDataFreshFromDatabase method, it will remove all traces of dataFresh.  You can execute dataFresh commands with a different account than your unit tests. Simply supply a different connection string.  dataFresh DOES REQUIRE sysadmin rights.

Thanks,

Mike