Static Data - Synced by SQL Compare or Data Compare?
This may sound like a very obvious quesion but I thought I knew the answer and now I am not so confident!
I have set-up a number of tables as Static Data within SSC. Commiting changes finds these and commits them. All Good.
When use SQL Compare to release my changes to my live database, is it SQL Compare that will update my live server with this new static data, whilst also making any database changes, or do I also have to use Data Compare to sync the new static data to live?
I was under the impression static data was handled by SQL Compare but as I am using SQL Compare this does not appear to be the case.
Could someone please confirm what I'm thinking. And if I do need to use Data Compare to release my static data changes to live, is there any way when using comparing two databases, to only look for changes to static data?