I often use Azure Data Studio's **Schema Compare** in lower environments like dev and uat, to get information about the schemas, before I commence with making changes and/or testing.
I need to compare the production schema (source of truth for the schema), to the lower environments as well. But, how do I know, that when I run the Schema Compare, I do not impact the production system? How do I know that I would not cause downtime or loss of data?
Obviously, if I *apply* a schema update on prod, that would have an impact. But I'm not asking about that, but rather specifically **the comparison operation itself**.
I could not find a statement from MS in the docs, that clarifies if Schema Compare is meant to be ran against production databases.

Asked by Divan
(97 rep)
May 13, 2024, 10:16 AM
Last activity: May 13, 2024, 03:58 PM
Last activity: May 13, 2024, 03:58 PM