There is no copy database wizard I'm trying to copy data from one table to another table in a different database. After right clicking I have got an option Tasks, under it there are only the two options:


Export Data...
Import Data...


... but no option for Copy Data.... 

How can I solve this issue? 

Thanks in advance.
You should use Export data and choose data source as SQL server native client (Version) as source and select your source SQL server instance and You should select the same for the destination with your Destination server name. On the next window select table, you want to copy and Run the wizard. This will copy all the data from your source table to destination table.

Also the copy database wizard is used to create a copy of your database not for copying data from table to table. Also if you can't see this option most probably you are using express edition here


  The Copy Database Wizard is not available in the Express edition.