Sample Header Ad - 728x90

Schema compare on production database

-2 votes
1 answer
110 views
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**. enter image description here 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