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>

      <FileName>..\Scripts\DoStuff1.sql</FileName>
    </value>
...

sultanofsuede 7 years ago

Comments

1 comment

I ended up writing a Powershell script to resolve the file paths and save the *.sqlgen projects as copies.

sultanofsuede 7 years ago

0