DB Watch Program for SQL

[kscheeler]

After reading the last few threads, I realized I had been using something in SQL that tells you what tables/fields get updated during a particular process.

There's a program called DBWatch at the website below ($25 per copy) which I had found through the Microsoft SQL Magazine.

http://www.fencel.com/

It basically loads your whole test database into memory. You would then do a process like enter a sales order and then click on a button in the program and it will tell you all of the tables and fields in the database that were added to / changed or deleted from. I've used Macola's demodata database to do this and it's worked fine.

Kevin Scheeler

 

[MacolaHelp]

Thanks for the info. I'm going to try it out. If it does what pervasive monitor can, I'll be happy & you'll get the star!

 

[dgillz]

Peggy,

Just curous if you tried this out yet and what your opinions are on this?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[MacolaHelp]

Don: haven't tried it yet. You know how it goes. I often delay on these tools until I have a crisis & must learn it on the fly. I'm planning on downloading & testing late this week or sometime next week. After using EM this weekend to fix file validation error rpts, I am ready for this!!