Activity overview
Latest activity by mbgrove
OK guys...
Yes, I can use the log file, even though it's not user-friendly in the way of placing or naming what we want and it states it's more for you guys in your online documentation.
Yes, I can take another step and generate a SQL script and run that separately with sqlcmd to be able to trap the error.
But I shouldn't have to. I would be taking a step backwards from the functionality of a previous version.
Fortunately, the multiple databases I have automated to be updated on a daily basis are not yet production databases. If these had been production databases and the output file, which had always worked before, suddenly no longer returns the information it did before, I would be screwed if there was an error, plain and simple.
So... what happened to /out? Honestly. I have been given no explanation or reason for why /out doesn't return the same information it did before, and there is no documentation to back up the fact that it doesn't return the same information it did before.
And, interestingly enough, you asked me to try a switch, /verbose, that isn't in the online command line documentation either.
I feel like I've gotten the run-around to avoid answering what happened to the /out feature.
Whether you want to admit it or not, this is a fairly serious change in the program that needs to be resolved in one way or the other.
1) Get /out to return what it did before.
2) Document that /out no longer returns specific information, or better document what information it DOES return.
Michael / comments
OK guys...
Yes, I can use the log file, even though it's not user-friendly in the way of placing or naming what we want and it states it's more for you guys in your online documentation.
Yes, I can...
Updated:
David,
The issue is that I want to see what the error is in the output file.
The database is messed up and will not update without manual intervention, but the output file doesn't indicate there was any problem.
Thanks.
Michael / comments
Updated:
David,
The issue is that I want to see what the error is in the output file.
The database is messed up and will not update without manual intervention, but the output file doesn't indicate...
Brian,
You mean like:
"D:\sqlcompare" /Project:"D:\Project.scp" /reporttype:simple /report:"D:\Project.html" /out:"D:\Project2.txt" /sync /verbose
Didn't know that was a command line switch as per it's not in the command line documentation I found. However, I did go ahead and try it. It gave me more information at the beginning, but still stops at the same place I noted in my original post.
Some clarification - The error I'm getting is when the SQL script is trying to run and it fails due to a problem with constraints or the like. This is not an error with SQL Compare 10 itself. Sorry if this confused the matter.
Thanks.
Michael / comments
Brian,
You mean like:
"D:\sqlcompare" /Project:"D:\Project.scp" /reporttype:simple /report:"D:\Project.html" /out:"D:\Project2.txt" /sync /verbose
Didn't know that was a command line switch as pe...
I had previously tested the log file avenue. Yes, it shows the errors that were received.
Are you saying that I'm stuck with the log files that I can't name or place where I want because the output files no longer return the information they used to? / comments
I had previously tested the log file avenue. Yes, it shows the errors that were received.
Are you saying that I'm stuck with the log files that I can't name or place where I want because the outpu...
To reiterate: I didn't have this problem with SQL Compare 8. If the database update failed, it showed on the screen/in the output file.
In an output file I could name and place myself, instead of a log file that is somewhere defined by the system named whatever it wants to be named.
There is nothing in the documentation that indicates that there are any changes in what gets sent to the output file.
I would like to know how to get the information I had before into the output file.
What good is an output file if it doesn't even tell me that the whole database synchronization failed?? / comments
To reiterate: I didn't have this problem with SQL Compare 8. If the database update failed, it showed on the screen/in the output file.
In an output file I could name and place myself, instead of...
Getting error notifications with command line
Having problems with SQL Compare 10 that I didn't have with SQL Compare 8.
Here's my command line:
"D:\sqlcompare" /Project:"D:\Project.scp" /reporttype:simple /report:"D:\Project.html" /out:"D:\Pr...