Need some help on SQL Azure db.
Microsoft SQL Azure (RTM) - 12.0.2000.8 Nov 17 2017 14:42:09 Copyright (C) 2017 Microsoft Corporation
How can I get Schema changes report on sql azure db? In ssms, when I right click the db->I dont see that report which tells me schema change history.If it is onPrem sql db, I used to right click -> reports - >standard reports -> Schema changes history and get all the changes done to the database.
Basically, I want to get a similar report if not SSMS GUI, can we get the same report using plain TSQL for azure db? Basically I wanted to check for schema changes between 2 dates which could have affected the database performance.