WriteToFileOptions

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

WriteToFileOptions

Postby stevepatches » Wed Jan 21, 2009 12:23 am

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
stevepatches
 
Posts: 7
Joined: Tue Nov 29, 2005 3:46 pm

Re: WriteToFileOptions

Postby Andras » Fri Jan 23, 2009 5:02 pm

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.
Andras
 
Posts: 249
Joined: Thu May 19, 2005 5:07 pm
Location: Cambridge, UK

Postby stevepatches » Fri Jan 23, 2009 9:46 pm

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.
stevepatches
 
Posts: 7
Joined: Tue Nov 29, 2005 3:46 pm


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests