Prevent Statistics from being extracted to scripts folder

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Prevent Statistics from being extracted to scripts folder

Postby abjacs » Wed Feb 10, 2010 6:34 am

Hi. I'm using SDK v7.0 to save a physical db as a scripts folder. The extraction executes fine, but the extracted create table statements contain create statistics statements. Is there some way I can prevent this from happening?

I have tried registering the physical database with Options.IgnoreStatistics, but, per the API documentation, it seems that the Options enumeration only applies to comparison/migration operations.

Thanks!
abjacs
 
Posts: 6
Joined: Fri Dec 19, 2008 8:34 pm

Postby Brian Donahue » Thu Feb 11, 2010 2:50 pm

Hi Alex,

Maybe the problem is simply that you need to remember to apply your options at both the comparewith method and BuildFromDifferences. If you do not add Options.IgnoreStatistics to BuildFromDifferences, then you are creating the script with the default options.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests