Activity overview
Latest activity by modernuniverse
These are binary files. In general, binary files are not tracked in source control because when you change a binary file, you cannot really see meaningful textual differences when you compare two versions. By the same logic, sdsc should not be tracked in source control. I advise you add them to the ignore settings of your source control software. For git, for instance, you add them to .gitignore file. / comments
These are binary files. In general, binary files are not tracked in source control because when you change a binary file, you cannot really see meaningful textual differences when you compare two v...
+1 please / comments
+1 please
@RichardL How about "Should they be under source control?" I assume since these are binary files, we should not source control them. Also, it looks like they are generated each time I run sqlcompare or sqldatacompare. Could you please clarify whether these files need to be tracked in our versioning system? If yes, what wiould be the harm not doing it - would it break sqlcompare? / comments
@RichardL How about "Should they be under source control?"I assume since these are binary files, we should not source control them. Also, it looks like they are generated each time I run sqlcompare...
Thank you Michelle. I have one more question. Then, what does /reportAllObjectsWithDifferences option include in the reports from this list: [image] From your earlier response, I understand that, for instance StaticData is not "reported" even if I use the /reportAllObjectsWithDifferences option. Is there anything else that would be missing in the reports from that list even if I used the /reportAllObjectsWithDifferences option. The reason I ask is that I am trying to understand what differences my automation may miss. / comments
Thank you Michelle.I have one more question. Then, what does /reportAllObjectsWithDifferences option include in the reports from this list:From your earlier response, I understand that, for instanc...
Thank you for your quick answer. Is /include:StaticData then only useful for scenarios where we also use /synchronize as an optin? Is there a reason why reports do not contain the differences? We have an automation task to check any discrepancies between the database and the source control files. We run a script to do this and we generate html reports from sqlcompare. However, the reports do not contain the static data differences; therefore, I am wondering if I need to update my script to also use sqldatacompare in addition to sqlcompare so that we can see both types of differences? Or is there another way? When you say deployment script output, does that show any differences or it only contains the final information that needs to be deployed? / comments
Thank you for your quick answer.Is /include:StaticData then only useful for scenarios where we also use /synchronize as an optin?Is there a reason why reports do not contain the differences?We have...
I checked this again and it looks like now they are included. I must have upgraded my version after I made the post above. I am glad the recent versions fixed the issue. I do not remember what my version was before. Thank you. / comments
I checked this again and it looks like now they are included. I must have upgraded my version after I made the post above. I am glad the recent versions fixed the issue.I do not remember what my ve...
I am using "SQL Compare Command Line V13.6.11.8947" / comments
I am using "SQL Compare Command Line V13.6.11.8947"
SQL Compare Command Line Tool's include StaticData option
SQL Compare command line tool's help/documentation shows that there is an include option to include static data differences/include:StaticDataFrom the documentation:...Given this, my question is as...
I tried all possible options without much luck: - objects with differences - objects selected for deployment - objects with differences and also include identical objects - objects selected for deployment and also include identical objects None of the html reports generated contain neither onlyin1 nor only2 differences. On the other hand, the xml report contains them. / comments
I tried all possible options without much luck:- objects with differences- objects selected for deployment- objects with differences and also include identical objects- objects selected for deplo...
SQL Compare - Interactive HTML Report does not show onlyin1 and onlyin2 differences
I am comparing a database and a source control folder. Then I am trying to create a report.There is a discrepancy between Interactive HTML Report and XML report I generate from SQL Compare.Both rep...