G'day,
In a group development/support environment I've setup a series of Command Line scripts + XML configuration files to report on the differences between database (SQL Compare). One of the problems I have is that each developer has a different locations (source control working directory) for these scripts and hence the paths in the SQLCompare command line XML file need to be relative.
If I try to have a path like the following
<commandline>
..
<scriptfile>..\Results\myChangeScript.sql</scriptfile>
..</commandline>
I get an error, about path being inappropriate ("..\" specifically). The aim was to have all the *problem* files report to a folder above where the SQLCompare.exe, *.bat and *.xml configuration files reside.
Its a bit of a limitation at the moment, might this be changed in a future edition or am I going to have to "program" the SQLCompare API to resolve the problem?
Thank you for your post.
In a group development/support environment I've setup a series of Command Line scripts + XML configuration files to report on the differences between database (SQL Compare). One of the problems I have is that each developer has a different locations (source control working directory) for these scripts and hence the paths in the SQLCompare command line XML file need to be relative.
If I try to have a path like the following
<commandline>
..
<scriptfile>..\Results\myChangeScript.sql</scriptfile>
..</commandline>
I get an error, about path being inappropriate ("..\" specifically). The aim was to have all the *problem* files report to a folder above where the SQLCompare.exe, *.bat and *.xml configuration files reside.
Its a bit of a limitation at the moment, might this be changed in a future edition or am I going to have to "program" the SQLCompare API to resolve the problem?