Unable to copy a DB from SQL Server 2000 to SQL Server 2012 using copy wizard

I am trying to copy a database from SQL Server 2000 to SQL Server 2012 using copy wizard in my local machine where SQL Server 2012 is installed. But, the wizard is not detecting destination server. Source DB is on a network and Destination is my local machine itself.

When I select the destination server as my local machine, I am getting the below error:


TITLE: Copy Database Wizard


The destination server cannot be a SQL Server 2005 or later Express instance.

Does Copy Database wizard not support if 'source' is earlier than SQL Server 2005 ? But the error message says only about 'Destination'. Here my destination is SQL Server 2012 and Source is SQL Server 2000.

The problem is not the version but the fact that the destination server is an Express instance. Copy database is not supported in the express edition of MSSQL.

Here's a link to a workaround solution:
https://stackoverflow.com/questions/4269450/copy-a-database-within-sql-server-express

If you just need the data, you can right click on the database name -> Tasks -> Import Data... to copy multiple table, although this will copy data and not other features like primary keys and other constraints.

StackExchange Database Administrators Q#78564, answer score: 5