Follow me on Twitter at Twitter.com/wbm
FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
Copy a database with Sql Server 2005 - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on Web, HTML5, Mobile, MonoTouch for iPhone, MonoDroid for Android, and Windows Azure.

News

Personal Blog

Work Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

Archives

Copy a database with Sql Server 2005

With Sql Server 2005, you no longer use the DTS wizard to move objects from one Sql Server database to another.  Go into the Sql Server Management Studio, select "Copy Database", and then follow the instructions.

Wally

Posted: Oct 21 2004, 11:49 AM by Wallym | with 3 comment(s)
Filed under:

Comments

Fred said:

Sure but you have to be sysadmin on both servers!  Big step backwards from DTS.  I need to copy a db from a hosted server.  The only good way I see is to install the sql server 2000 client....

# February 6, 2007 11:14 AM

Sami said:

Wizard Creates a Data Transformation Services (DTS) Package

The Copy Database Wizard creates a DTS package that runs on the destination server and can be run either immediately or can be scheduled to run later.

from support.microsoft.com/.../en-us

# July 13, 2007 5:33 PM

jesús said:

still, the copy wizard can't be accesed if you're not sysadmin. problem when you have to copy from network solutions to somewhere else or viceversa...

# August 2, 2007 9:26 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)