"тнιѕ вℓσg ¢συℓ∂ ѕανє уσυя мσηєу ιƒ тιмє = мσηєу" - ∂.мαηנαℓу

Sunday 31 May 2020

How to Compare Two SQL Database Schemas from Visual Studio?

Is it possible to compare SQL Database schemas from Visual studio? The answer is yes. Recently I had to do some comparison of DBs and my colleague recommended this option. It's already described in the below link so I am not repeating the steps.

Just be careful when you deal with it. Make sure that you do proper backups and also test properly in lower environment schemas before making changes in production. It's always good to use production one as the guid in order to sync the lower environments.

https://www.sqlshack.com/how-to-compare-two-sql-databases-from-visual-studio/


No comments:

Post a Comment