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!
精彩评论