WriteToFileOptions

stevepatches

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

Andras B

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

stevepatches

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.