.netgitvisual-studio-2015azure-sql-databaseschema-compare

How to view history of database updates


If I have a database project that's connected to an Azure Sql db v12, is there a way to see a history of the "Schema Updates" I've run on that database? Similar to a Git history of commits? I know there's something called a refactorlog and I looked around a little to see if that could be of some help but it doesn't appear to be. Thanks in advance.


Solution

  • If you didn't enable auditing or some custom solution to capture changes,you have no way to see historical changes..With that said,below are some of options you can try to capture schema changes in azure.

    1.DDL triggers
    2.SQL azure Auditing feature