Data comparison between a live database and a script folder?

Trikeb · September 17, 2007 3:26PM

Hi,

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

David Atkinson · September 17, 2007 4:33PM

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

Data comparison between a live database and a script folder?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk