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?
Asked
Active
Viewed 189 times
1
-
you can use this redgate tool http://www.red-gate.com/products/sql-development/ – Eric K Yung Sep 16 '13 at 15:07
1 Answers
2
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.
Milen
- 8,697
- 7
- 43
- 57