An error while copying database

Question

An error while copying database

SQL_Surfer

SSCrazy Eights

Points: 8320
More actions
November 17, 2013 at 1:25 pm

#395841

I am trying to use Copy database wizard to copy databases from 2005 to 2012 sql server, but I'm getting error "An entry with same key already exists". What does this mean?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Any idea on what kind of object it fails?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQL_Surfer SSCrazy Eights Points: 8320 More actions · Answer 2

It failed on master stored proc objects. I skipped that and its working now. But its been alreay an hour and the process to copy is still runnng. DB size is 160GB. Is it usually slow? I am copying it to VM from physical serverl.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Wouldn't a compressed full backup/restore have been faster?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQL_Surfer SSCrazy Eights Points: 8320 More actions · Answer 4

can't take compressed backup on 2005...what are other options? because other dbs are pretty similar in size.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

You could do an uncompressed back-up/restore.

Or do the data migration in SSIS itself so you can exploit parallellism to the max. (not sure how the copy database task uses parallellism).

ps: since this is a sql 2012 forum, you would expect questions about 2012, nt 2005 😉

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQL_Surfer SSCrazy Eights Points: 8320 More actions · Answer 6

Thanks. Any idea how to copy the list of linked server from 2005 to 2012? I didn't see the option in SDT.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 7

SQL_Surfer (11/17/2013)
Thanks. Any idea how to copy the list of linked server from 2005 to 2012? I didn't see the option in SDT.

You can script them out. You can either right-click on each one and script them seperately, or you can retrieve the info from sys.servers.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Koen Verbeeck (11/17/2013)
Wouldn't a compressed full backup/restore have been faster?

A normal uncompressed backup/restore would likely have been faster and less prone to random failures.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Perry Whittle SSC Guru Points: 234013 More actions · Answer 9

SQL_Surfer (11/17/2013)
can't take compressed backup on 2005...what are other options? because other dbs are pretty similar in size.

install the trial version of Litespeed and use that to compress and move the backups.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉