Create Subdirectory per Schema

jpmsql

We can use the <WriteToFileOptions> node in RedGateDatabaseInfo.xml to customize our folder structure and it works great (e.g., a directory called "storedProcs" instead of the default "Stored Procedures").   However, when SQL Compare deploys to that directory, all files are placed in that directory - which can be a lot of files.  It would be great to create a sub-folder per schema (e.g., storedProcs\dbo\dbo.Proc.sql, instead of storedProcs\dbo.Proc.sql).

Possibly it can be done with RedGateDatabaseInfo.xml with something along these lines - but I haven't been able to find a syntax guide online

<WriteToFileOptions>

    <Prefixes>

      <None>

      </None>

      <Table>tables</Table>

      <StoredProcedure>storedProcs\{{SchemaNameHere}}</StoredProcedure>

  

DanC

Hi @jpmsql

Thank you for the suggestion, would you mind posting it on the UserVoice here which the Product Managers will review for upcoming features? https://redgate.uservoice.com/forums/141379-sql-compare