Activity overview
Latest activity by robermar2
Have you guys tried executing the same kind of thing in a power shell script instead of a batch file in an attempt to "eat" error code 63?
I would think this would work fine, but I am running into some issues where the compare works, but any output I request does not.
I am passing parameters for the script file output, html report as well as trying to limit the scope of the compare using a filter file. When passing this directly to the command line, it works fine.
However, when trying to pass all of this through a power shell script, I receive no errors, the compare works, but it ignores my filter file, does not output the script file and it does not save the html report.
I am going to submit a support ticket and provide you the power shell script I am trying to run. / comments
Have you guys tried executing the same kind of thing in a power shell script instead of a batch file in an attempt to "eat" error code 63?
I would think this would work fine, but I am running into ...
I tried using the /assertidentical switch so that the command line does not fail when the schemas are identical.
However, now I receive this error:
Error: The /assertidentical switch cannot be used in conjunction with the
/synchronize switch. Please use SQLCompare.exe /? or SQLCompare.exe for more information.
I am actually trying to deploy changes, if there are any, so I have to use /synchronize. I also save the delta script to a file using /sf.
I don't understand why I can't use the switches at the same time.
I want to use a filter. I want to actually have the changes committed to the database being compared. I don't want it to fail if the schemas happen to be identical.
Any help would be greatly appreciated. / comments
I tried using the /assertidentical switch so that the command line does not fail when the schemas are identical.
However, now I receive this error:
Error: The /assertidentical switch cannot be used...
Great, I will give that a try.
Thanks for the quick response. / comments
Great, I will give that a try.
Thanks for the quick response.
Command line and /Include:Identical and /Filter
We are using the sql command line to help automate our database deployments.
In order to not get build failures when the schemas happen to be exact, we have to use the /Include:Idential switch for ...
SQL Compare command line and /migrationfolder switch
My company just purchased a large set of licenses for sql source control and sql compare for our automated build agents that use team city and svn.
We are attempting to include our databases in our...