Data comparison between a live database and a script folder?

TrikebTrikeb Posts: 13
edited September 17, 2007 4:33PM in SQL Toolkit Previous Versions

Is it possible to perform a DATA compare between a live database and a script folder? It works for the SCHEMA but I can't figure out how to do the same with a data script file.

Thanks in advance,

Jonathan Comeau


  • Hi Jonathan,

    Currently SQL Data Compare will not read a scripts folder for data. This is something we are actively considering for a future release. Can I ask what format your data is held in? I presume you are trying to store static/lookup data as a script to store with your schema script files?

    It is possible that there are workarounds that may work for you, one that involves first deploying the data to a temporary database using, for example the SQL Data Compare command line, and subsequently comparing this database to your target.

    Once we have gathered sufficient user feedback about the format of the data files, we will look to incorporating this into SQL Data Compare.

    Kind regards,

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.