2xMax
Reputation: 1752
ssms copy database
I have a local sql express server with DB A and remote server uXXX.mssql.domainname.com with DB B.
using sql 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).
Upvotes: 0
Views: 1548
Answers (1)
Raj More
Reputation: 48016
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!
Upvotes: 1
Related Questions
- How to copy table from one Data Base to another?
- SQL Server Copy database to different server
- Copying a table from one SQL server and DB to another using SQL Server management studio
- how to copy a database in SQL server management studios
- How to copy an existing DB in SQL Server 2008 r2 management studio?
- How to copy database in ssms Express version
- Copying databases in sql server
- how can copy a database to an other use mssql managment studio
- Copying SQL Server Data to another Database on another Server
- How do I copy a SQL Server database