开发者

Is there a way to disconnect a Visual Studio 2008 Schema Compare from a database without closing the schema compare?

开发者 https://www.devze.com 2023-01-09 20:47 出处:网络
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

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
0

精彩评论

暂无评论...
验证码 换一张
取 消