Copy Database Wizard not available | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Copy Database Wizard not available

When I right click on a database and click on the Tasks, I cannot find the Copy Database entry. Do I need to install something or change some settings to able to have the Copy Database Wizard? Note: I’m guessing it may be related to no Integration Service.
Thanks, Peter
I only have 2005 tools.<br />If I use Managment Studio, database, righ click, task, I have Copy Database entry.<br /><br />Microsoft SQL Server Management Studio9.00.2040.00<br />Microsoft Analysis Services Client Tools2005.090.2040.00<br />Microsoft Data Access Components (MDAC)2000.085.1117.00 (xpsp_sp2_rtm.040803-215<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /><br />Microsoft MSXML2.6 3.0 4.0 6.0 <br />Microsoft Internet Explorer6.0.2900.2180<br />Microsoft .NET Framework2.0.50727.42<br />Operating System5.1.2600<br /><br />FYI.<br /><br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">All in Love is Fair <br />Stevie Wonder<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
Hi Luis, So, you have not installed Integration Service.
Peter
Nop.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Hi Luis, What happen when you click the Copy Database? Based on the BOL, Integration Service is a requirement for Copy Database Wizard.
Thanks, Peter
When the wizard begin I can choose the database I want to copy (server, database). Next step is for destination server or instance but rigth now I have no 2005, so the message is something like: Must be a 2005 server. So, apparently all works but I’m no shure if in the followings steps there is something about IS. Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Hi Luiz, I actually have the Copy Database Wizard but it only will appear for non System Database Tasks. This is SQL Server 2005 Developer Edition with SP1. But for SQL Server 2005 Express with SP1, it does not appear even for non System Database. Does it mean not supported?
Peter
I suppose because I have enteprise edition.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
This is availabel in workgroup edition and standard edition as well —————————————-
http://dineshasanka.blogspot.com/
From BOL, To use the Copy Database Wizard, you must be a member of the sysadmin fixed server role on the source server, as well as on the destination server. In other words, you must be an administrator on the server from which the database is to be copied, as well as an administrator on the server to which the database is being copied. To transfer the databases using the detach and attach method, you must have file system access to a file system share containing the source database files —————————————-
http://dineshasanka.blogspot.com/
]]>