August 28, 2019 at 6:49 pm
Hi,
Is there any way to compare schema changes for all databases in an instance? I want to compare at instance level for dbs before and after a production release.
Thanks
Gana
August 28, 2019 at 7:30 pm
One option is you can view the schema changes and likely easiest way would be to view the Schema Changes History report at the server level - in SSMS, right click on the instance, Select Reports, select Schema change History. Otherwise you would want to go through the default trace file which is what the report does.
Sue
August 29, 2019 at 4:15 pm
Schema Changes History report at the server level shows " Alter Index" that we do daily for index defrag. This is not going to help.
Do I need to look for a tool? or anything available in SQL server for schema comparison?
Or do I need to generate scripts for all objects and upload to a version control and when even I need to compare, then generate a new script for all objects in a DB and compare with what we have in version control?
How o you guys manage?
August 29, 2019 at 8:09 pm
SQL Compare works well https://www.red-gate.com/products/sql-development/sql-compare/
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply