I have 3 instances of Sql (2008 R2) on 3 different servers. The versions are (10.50.2550.0 SP1 Standard Edition (64-bit), 10.50.2550.0 SP1 Standard Edition (64-bit)). The goal is to migrate all the databases and logins to new server, we just purchase with Sql server 2012.
I don’t know how to approach, I tried to use the copy database wizard and it keep failing. If I decide to backup each database and restore them to new the servers, I don’t know how to migrate the logins.
What is the best approach to deal with the situation?
Sorry about the confusion: (More details about the issue)
- Number of databases to be moved : 10
- Error listed during the copy database wizard:
Line 60:
OnError,DUPFAIDS,NT AUTHORITY\SYSTEM,DUAPPSRV1_EXAPPSVR1_DUPFAIDS_PFAIDS_Transfer Objects Task,{8F0C82BB-4C5D-4796-BE75-BAB033C59039},{3818CD1B-9685-46B7-AFE2-AE0FE962DA03},
12/3/2014 12:10:15 PM,12/3/2014 12:10:15 PM,0,0x,ERROR : errorCode=-1073548784
description=Executing the query "--------------------------------------------------..." failed with the following error: "Invalid object name 'xwd_window_disabled_objects'.".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.**
I tried to use the copy database wizard and it keep failing.
--> can you elaborate this sentence? What error message did you get when using database wizard? Please see How can I ask better questions on Server Fault? – masegaloeh Dec 3 '14 at 22:10