Home All Groups Group Topic Archive Search About

Copy Database Wizard : where is it?

Author
6 Mar 2007 8:24 AM
Oscar
I own an MSDN subscription. After I installed SQL server 2005 I've noticed
that it shows SQL Server 2005 Express.
For a reason that I don't know it doesn't show a Copy Database context menu
right after right clicking at a database. I also don't see any wizard in
management. Do I need to install anything additionaly?

regards,
Oscar

Author
6 Mar 2007 11:15 PM
Erland Sommarskog
Oscar (o**@xs4all.nl) writes:
> I own an MSDN subscription. After I installed SQL server 2005 I've
> noticed that it shows SQL Server 2005 Express. For a reason that I don't
> know it doesn't show a Copy Database context menu right after right
> clicking at a database. I also don't see any wizard in management. Do I
> need to install anything additionaly?

It seems that the CDW is not supported with SQL Express. Since CDW relies
on Integration Services, and Express does not come with Integration
Services it's logical. Then again, what if you have another edition on
your machine, and you have Integration Services rnnning after all? (I have
this, and I used tried the context menu on a SQL Express instance.)

Then again, CDW is of limited use. The SMO method has been somewhat improved
in SP2, but there is still stuff that does not work.


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button