Copy DB from SQL Server 2008 to SQL Server 2012 I have several databases on SQL Server 2008 that I wish to transfer to SQL Server 2012.

The two servers are on the same network but separate domains.

I am attempting a DB Copy from the one server to the new one and it connects successfully
I just am not allowed to select any of the DB instances to copy to the new server.

I have been attempting the connection from the 2012 end. I have DB sysadmin IDs at both
ends.

Any advice is appreciated.

Lou
DB Copy has a number of limitations as describe at: http://msdn.microsoft.com/en-us/library/ms188664.aspx

This includes not supporting the copying of System databases, Databases marked for replication, or any database not in a normal status.

However, it does support moving logins, jobs, and so forth.

The typically best way to copy a database with the fewest issues is to do a BACKUP from the source server and a RESTORE on the target server.  This is mentioned here in the discussion of strategies for copying databases:

http://msdn.microsoft.com/en-us/library/ms189624.aspx

If you also need to copy logins from the old to the new server, there are a couple of scripts documented at:  http://support.microsoft.com/kb/246133

SQL Agent Jobs can be scripted and recreated on the target server as well.