What are the challenges you face when working across database platforms? Take the survey
Options

scriptsfolderxml format

ehuggzehuggz Posts: 10 Bronze 1
edited September 20, 2012 10:39AM in SQL Compare Previous Versions
I am working through the NANT scripts provided by my Red Gate Salesman for CI Automation with TeamCity and am having some issue with the upgradescript.build file section"generate_upgrade_script_schema" which access the source repository directly via the /scriptsfolderxml flag.

I get "Error: The file <path>LocationToTesting.xml containing the script folder location XML fragment could not be parsed."

I tried several of the suggestions for the scriptsfolderxml format, even copying the <ScriptFolderLocation></ScriptFolderLocation> section from the project file generated by the UI after comparing Source to DB successfully.

SQL Compare is version: 10.2.0.1337

The scriptsfolderxml file is "LocationToFile.xml"
and presently contains the information below (I've tried many combinations).

Does anyone know the exact format required for the /scriptsfolderxml flag when accessing TFS2010?
&lt;ScriptFolderLocation&gt;
&lt;!--
SQL Compare
SQL Compare
Version:10.2.0.1337--&gt;
&lt;ISOCCompareLocation version="1" type="TfsLocation"&gt;
  &lt;ServerUrl&gt;http://pin-tfs2010:8080/tfs2010/ssdtprojects&lt;/ServerUrl&gt;
  &lt;SourceControlFolder&gt;$/AWS2008LT/AWS2008LT&lt;/SourceControlFolder&gt;
&lt;/ISOCCompareLocation&gt;
&lt;/ScriptFolderLocation&gt;
The NANT section in question is:
&lt;property name="migration.folder" value="Migrations" overwrite="false" /&gt;
&lt;property name="production.revision" value="3" overwrite="false" /&gt;
&lt;property name="ci.server" value="WEB01" overwrite="false" /&gt;
&lt;property name="ci.database" value="AdventureWorks_TeamCity" overwrite="false" /&gt;
&lt;property name="ci.workingdirectory" value="$&#123;environment::get-variable&#40;'CHECKOUTDIR'&#41;&#125;" overwrite ="false" /&gt;
&lt;property name="ci.user" value="AB" overwrite="false" /&gt;
&lt;property name="ci.pw" value="P1" overwrite="false" /&gt;
&lt;property name="ci.versioncontroluser" value="tc" overwrite="false" /&gt;
&lt;property name="ci.versioncontrolpw" value="B3" overwrite="false" /&gt;
&lt;property name="latest.scriptsfolder" value="$&#123;environment::get-variable&#40;'checkoutDir'&#41;&#125;\AWS2008LT" overwrite="false" /&gt;
&lt;property name="repo.location.xml" value="$&#123;ci.workingdirectory&#125;\NantBuildScripts\LocationToTesting.xml" overwrite="false" /&gt;
&lt;property name="latest.revision" value="$&#123;environment::get-variable&#40;'BUILD_NUMBER'&#41;&#125;" overwrite="false" /&gt;
&lt;exec program="$&#123;sqlcompare.executable&#125;" resultproperty="returncode" failonerror="false"&gt;
&lt;arg value="/scripts1:&quot;$&#123;latest.scriptsfolder&#125;&quot;"/&gt;
&lt;arg value="/revision1:$&#123;latest.revision&#125;"/&gt;
&lt;arg value="/sourcecontrol2"/&gt;
&lt;arg value="/revision2:$&#123;production.revision&#125;"/&gt;
&lt;arg value="/scriptsfolderxml:$&#123;repo.location.xml&#125;"/&gt;
&lt;arg value="/migrationfolder:$&#123;migration.folder&#125;"/&gt;
&lt;arg value="/AbortOnWarnings:high"/&gt;
&lt;arg value="/options:Default,IgnoretSQLt"/&gt; 
&lt;arg value="/ShowWarnings"/&gt;
&lt;arg value="/verbose"/&gt;
&lt;arg value="/Report:&quot;PreUpgradeReport_Schema.html&quot;"/&gt;
&lt;arg value="/ReportType:Simple"/&gt;
&lt;arg value="/ScriptFile:&quot;UpgradeScript_Schema.sql&quot;"/&gt;
&lt;arg value="/force"/&gt;
Eric Huggins | Continuous Integration Manager
Pinnacle of Indiana

Comments

Sign In or Register to comment.