December 12, 2017 at 12:37 am
Hi All,
Need some help on SQL Azure db.
Environment:
select @@version
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.
Thanks,
Sam
December 12, 2017 at 6:22 am
That's not available in Azure SQL Database because you're not dealing with a server, which uses default trace to generate the report. Instead you're dealing with a database as a platform. It's just not the same as having a SQL Server instance. You can add tracking for that using Extended Events, however, it's on you to set it up, maintain it, create reports off of it. You'd be better using some kind of source control system to maintain & deploy schema changes to the database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 12, 2017 at 11:30 am
Okay. Thanks Grant.
July 11, 2019 at 6:59 pm
Except that it isnt really useful when trying to find the rogue who applied a schema change without recording it in version control. That schema report was/is great for that.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply