What are the challenges you face when working across database platforms? Take the survey
Options

Exclude Scripts from folder

alex.weatherallalex.weatherall Posts: 54
edited March 10, 2009 5:22AM in SQL Compare Previous Versions
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
Alex Weatherall
TeleWare.com

Comments

  • Options
    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
    David Atkinson
    Product Manager
    Redgate Software
  • Options
    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
    Alex Weatherall
    TeleWare.com
  • Options
    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
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.