Let's say I want to (using V开发者_如何学运维isual Studio) run a schema comparison between two databases, restore one of them from a backup, and run the schema comparison again. The schema comparison maintains a connection to the database, and SQL Server won't let me run the restore without removing all connections. Is there a way I can force the schema comparison to disconnect without closing it?
You could:
- Close all activities on the database (MSSMS right click on server > Activity monitor > close processes)
- Delete the database (check close all connections) then restore the database
- Change the connection to other database
- Save the schema compare > close it > restore > open schema compare
精彩评论