Options

Create Subdirectory per Schema

jpmsqljpmsql Posts: 1 New member
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>

  
Tagged:

Answers

Sign In or Register to comment.