How can we help you today? How can we help you today?

Custom script folder structure

Hello,

I'm syncing a database source with a script folder (.sqlproj) target using SQLCompare command line.  Is there a way to specify a custom folder structure for the script folder?  I've searched, but haven't found an option to specify a custom folder structure.  

My project is organized like this C:\ProjectName\Schema\ObjectType

Example:  
C:\CRM\dbo\Tables
C:\CRM\dbo\Stored Procedures
C:\CRM\dim\Tables
C:\CRM\dim\Stored Procedures
C:\CRM\fact\Tables
C:\CRM\fact\Stored Procedures

Objects that already exist in the target folder work fine, but new objects use the default folder structure C:\ProjectName\ObjectType, but I need to maintain the C:\ProjectName\Schema\ObjectType structure.

RobertT
0

Comments

1 comment

Sort by
  • sam.blackburn
    SQL Compare creates a configuration file in the scripts folder, usually called RedGateDatabaseProperties.xml.  You may be able to hand-edit this file to describe the directory structure you need.
    sam.blackburn
    0

Add comment

Please sign in to leave a comment.