Search results matching tag 'Support'

Re: Tracking db changes

mike.brockey — Fri, 09 Feb 2007 16:06:23 GMT

We track changes at a table level. Meaning, when a change occurs we write the name of the modified table to a table called df_ChangeTracking. This table is cleared when you call the RefreshTheDatabase method.

Re: Snapshot not being created

mike.brockey — Fri, 09 Feb 2007 01:56:31 GMT

Two things to check. If you are running SQL 2005 please make sure that you turn on xp_cmdshell. Also, if you have renamed your computer at any point since installing SQL server, please read and follow the instructions in this post to correct the internal server name that SQL server uses.

Re: Snapshot not being created

mike.brockey — Tue, 23 Jan 2007 15:08:38 GMT

The snapshot path needs to be a path only visible to SQL Server. I've never used UNC for dataFresh but imagine that it should work fine. You would simply need to ensure that the user account that the SQL Server service is running as has access to the network path.

Re: Snapshot not being created

Anonymous — Wed, 13 Dec 2006 21:51:23 GMT

Is this SQL 2000 / VS2003? Are you calling dataFresh from the API or by using the console application? Can you send me the create script of your database?

Re: DataFresh, SQL 2005 & xp_cmdshell

mike.brockey — Sun, 26 Nov 2006 04:38:15 GMT

Sorry, xp_cmdshell is required in the current version of dataFresh. We will investigate alternative options in the future.

Re: some questions about DataFresh

mike.brockey — Wed, 22 Nov 2006 16:33:57 GMT

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

some questions about DataFresh

Anonymous — Wed, 22 Nov 2006 08:37:37 GMT

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

Re: Reference Problem with Vista

mike.brockey — Fri, 17 Nov 2006 15:55:06 GMT

Thank you for the feedback, we have setup a Vista / VS 2005 environment and are attempting to reproduce this issue.

Re: problems with DataFreshInstance.RefreshTheDatabase();

mike.brockey — Tue, 14 Nov 2006 21:30:22 GMT

Mind posting the code where you are preparing your database?

PREPARE should be called once your database has been created including the execution of setup.sql. If you are calling PREPARE with an argument of false, this will delay the generation of your snapshot, you must then call the CreateSnapshot method. Otherwise your tables will be cleared and there will be no data to restore.

Re: Reference Problem with Vista

mike.brockey — Tue, 14 Nov 2006 21:24:30 GMT

I've not come across this issue. Maybe becuase I've not used it that environment. :) I will do a little research, stay tuned.