Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

An error while copying database Expand / Collapse
Author
Message
Posted Sunday, November 17, 2013 1:25 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 14, 2014 6:29 PM
Points: 327, Visits: 852
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?
Post #1515021
Posted Sunday, November 17, 2013 1:33 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
Any idea on what kind of object it fails?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1515022
Posted Sunday, November 17, 2013 2:42 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 14, 2014 6:29 PM
Points: 327, Visits: 852
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.
Post #1515024
Posted Sunday, November 17, 2013 2:44 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
Wouldn't a compressed full backup/restore have been faster?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1515025
Posted Sunday, November 17, 2013 3:03 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 14, 2014 6:29 PM
Points: 327, Visits: 852
can't take compressed backup on 2005...what are other options? because other dbs are pretty similar in size.
Post #1515027
Posted Sunday, November 17, 2013 3:14 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
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




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1515028
Posted Sunday, November 17, 2013 5:18 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 14, 2014 6:29 PM
Points: 327, Visits: 852
Thanks. Any idea how to copy the list of linked server from 2005 to 2012? I didn't see the option in SDT.
Post #1515041
Posted Monday, November 18, 2013 12:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1515107
Posted Monday, November 18, 2013 12:44 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:09 PM
Points: 42,434, Visits: 35,487
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 2008, MVP
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

Post #1515114
Posted Monday, November 18, 2013 2:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 6,162, Visits: 13,305
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"
Post #1515135
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse