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>
Hi @jpmsql
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