开发者

ssms copy database

I have a local sql express server with DB A and remote server uXXX.mssql.domainname.com with DB B.

using sq开发者_如何学Gol mangament studio 2008, I want to move copy DB A to DB B with all tables, data, dependencies and stored procedures.

how to figure out this problem? I only had understood table and table data copying(using Tasks->Import Data).


Use the Copy Database Wizard

In SQL Server Management Studio, go to the Object Explorer, expand the list of Databases, right-click your database "B", and in the pop-up menu expand Tasks, and then click Copy Database, choose your destination server, and you're home!

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜