How can we help you today? How can we help you today?

scriptsfolderxml format

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;
ehuggz
0

Comments

3 comments

Sort by
  • mattwhetton
    I'm actually working in a TFS environment, but I think I've just worked this out!

    You were almost there when you copied the ScriptFolderLocation section:

    I copied the contents of that section (which is xml encoded), ran it through an xml decoder (like here: http://coderstoolbox.net/string/) and then saved it to a file. Then I pointed the scriptsfolderxml flag at the file I just created.

    I had to do a bit more work to get the migration folder bits to work but this got me started. I'll try to write a blog article on what I've done when I get chance.

    Matt
    mattwhetton
    0
  • mattwhetton
    Just by way of an update, I've stepped through this in a little more detail in and article on my blog (http://www.codenutz.com):

    http://www.codenutz.com/2012/09/continuous-database-deployment-with-red.html

    regards

    Matt
    mattwhetton
    0
  • Brian Donahue
    Hi,

    I did some work with this last week, and I think the long and the short of it is, the <ServerUrl> element is just the base URL for the server and the <SourceControlFolder> contains only the relative path.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.