Data comparison between a live database and a script folder?
Trikeb
Posts: 13
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
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
Jonathan Comeau
Trikeb
Trikeb
Comments
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
Product Manager
Redgate Software