Exclude Scripts from folder

alex.weatherall

Hi,

We keep (large) default data insert scripts with our tables in VSS and SQL Compare runs these when trying to process the Script Folder. This can hang (or it takes a long time) SQL Compare during the database registration Post Processing Actions step.

Is it possible to define folders / files to ignore during compare with a Scripts folder - or could this be added as a feature.

Thanks,

Alex Weatherall

David Atkinson

Are these in separate files or in the same files as the CREATE TABLE statements? If they're in separate files, I'm wondering whether we can simply stop parsing files as soon as we spot an INSERT?

David Atkinson
Red Gate Software

alex.weatherall

Hi David,

They're in separate files. We have a folder called Static Data that we use to store the files with inserts.

An alternative would to be exclusive about the folders used on the compare. So that only folders defined in the SQL Compare options area are actually used (optionally) rather than parse every .sql file under the top level folder - just a thought.

Alex Weatherall

David Atkinson

That's an good idea and one that we'll have to make a decision on fairly shortly as we intend to support static data as part of the scripts folder via support from SQL Data Compare Pro. I'll make sure we consider this and will let you know what decision we come to do you can further comment on this.

David