Competition: What’s your favorite Redgate tool? Enter now.

SQL Data Generator - relative pathing for SQL pre/post scripts

I found this old article. 

https://forum.red-gate.com/discussion/11878/how-can-i-use-relative-paths-with-sqlgen-files

Not sure if this defect was picked up and worked on by RedGate.  I'm using 4.x.

I want to configure the *.sqlgen file to use relative paths.  It's not realistic in software development to use hard-coded paths and I'm sure the tool supports it, but I've not figured out the steps and the SDG help documentation is thin.  Googles are turning up nada.

Various combinations on FileName don't work and I can't find the XSD for the sqlgen file.  Everything redirects to %windir%\System\

TIA

  <PostScripts type="SQLScripts" version="1">
    <value version="1" type="SQLScript">
      <SQLScriptType>ExternalSQLFile</SQLScriptType>
      <Name>DoStuff1.sql</Name>
<!-- Relative Path -->
      <FileName>..\Scripts\DoStuff1.sql</FileName>
    </value>
...


Comments

Sign In or Register to comment.