Options

Data Compare Pro Log

EACC_NZEACC_NZ Posts: 17
edited August 8, 2007 10:13PM in SQL Data Compare Previous Versions
Hi, I have two "nice to haves" with regard to the log in Data Compare Pro:
1. When appending the log, is it possible to have it generate a timestamp with each new entry?
2. Is it possible to specify the directory where the logs are stored, I've tried but the "address" seems to get truncated during the running of the script.
Regars

Colin
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    Sorry for my confusion, but which log are you referring to?
    · Share on Twitter
  • Options
    EACC_NZEACC_NZ Posts: 17
    Sorry about the delay - I've been chasing my tail with some other projects of late.

    The logs I refer to are the ones created by Command Line when it runs the Data Compare Scripts. Currently I have three projects running in one batch file (which is scheduled every hour), and the results being appended to a .txt file. With the results being appended without any date/time stamp, it becomes difficult to ascertain exactly when problems have started to occur.

    I hope this makes sense!

    Cheers
    Regars

    Colin
    · Share on Twitter
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    You can use the date and time commands in your script file to append the dates and times into your script, for example: 
    REM Save this test as datasync.bat
@ECHO OFF
FOR /F "tokens=1-3 delims=/ " %%i IN ('DATE /T') DO SET thedate=%%i-%%j-%%k
FOR /F %%i IN ('TIME /T') DO SET thetime=%%i
ECHO Database Comparison on %thedate% at %thetime% >> DataCompare-%thedate%.txt
"c:\program files\red gate\sql bundle 5\sqldatacompare" /db1:widgetdev /db2:widgetlive >> DataCompare-%thedate%.txt
    · Share on Twitter
  • Options
    EACC_NZEACC_NZ Posts: 17
    :lol:
    Regars

    Colin
    · Share on Twitter
Sign In or Register to comment.