What are the challenges you face when working across database platforms? Take the survey
Options

WriteToFileOptions

stevepatchesstevepatches Posts: 11
Hi,

Can someone provide more information on how WriteToFileOptions works when calling SaveToFolder? I am trying to do several things with it but I don't see how in the documentation:

1 - drop the dbo. prefix in certain cases
2 - use a different directory structure
3 - overwrite existing files rather than adding a 1 2 3 etc prefix

Thanks in advance,
-Steve

Comments

  • Options
    Hi,

    Can someone provide more information on how WriteToFileOptions works when calling SaveToFolder? I am trying to do several things with it but I don't see how in the documentation:

    1 - drop the dbo. prefix in certain cases
    2 - use a different directory structure
    3 - overwrite existing files rather than adding a 1 2 3 etc prefix

    Thanks in advance,
    -Steve

    Hi Steve,

    the answers:
    1 - you cannot do this
    2 - you can specify directory prefixes, e.g. foo\bar\ will put the items into the foo\bar\ subfolder
    3 - you cannot do this

    Regards,
    Andras
    András Belokosztolszki, PhD
    Red Gate Software Ltd.
  • Options
    For #2, sorry I wasn't clear on the question. The tool produces directories like this:

    Functions
    Security
    Stored Procedures
    etc.

    But what if I want directories like this:
    Functions
    Roles
    Schemas
    Users
    Procedures

    I see an ObjectPrefixes property but it's read-only.
Sign In or Register to comment.