SQL Data Generator - relative pathing for SQL pre/post scripts
sultanofsuede
Posts: 2 New member
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>
...
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