One requirement of this plugin is that in order to be able to keep a full history of who changed what, a custom ChangeLog database must be created. The tool will work without this database but changes are kept in TempDB which means every time the server restarts, we lose the history. (See: http://documentation.red-gate.com/displ ... +databases )
This was the reply from the senior DBA:
Reviewing..would rather see dedicated db instead of tempdb. But, if we want to do this â€“ why not just have us enable change log tracking on specific databases?
So - question - CAN SC3 use existing sql change log tracking if it's been enabled?