WriteToFileOptions

Comments

• Andras B Redgate › Posts: 249

  January 23, 2009 11:02AM

  stevepatches wrote:

  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.

  0 · Share on Twitter
• stevepatches Posts: 11

  January 23, 2009 3:46PM

  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.

  0 · Share on Twitter