Search code examples
sqlsql-serverschema-design

SQL server schema change

I have a local copy of a sql server 2008 database. I'd like to know if any tables or views, schemas - not data, are out of sync with the copy on the server. Is there any easy ways to find out?

Solution

  • If you're using Visual Studio - SQL -> Schema Compare and specify Source ant Target DB.
    It shows all of the Schema changes and it also generates a change script for the differences.
    Fast and efficient way to keep your DB in sync.