ramana3327 (8/26/2014)
First we have to run the upgrade adviser to know the potential issues.
Yes, this is a basic requirement, you want to know where compatibility issues will lie.
ramana3327 (8/26/2014)
Then we can take the full backups of all databases and apply those in 2012 then apply all databases transactional logs with recovery into the new environment then run the dbcc check db, creating the logins & users and changing the compatibility and update the statistics and connect the application then create the jobs
Since you have a new cluster you'll need to change connections strings in your apps, unless you also migrate the Virtual IPs and network names too.
ramana3327 (8/26/2014)
If we have TDE enable in any of the databases then we have to backup the master key & service key then restore those on the target environment.Thanks,
No, no, no, no, no!!
You only require a backup of the certificate and its private key from the source server, these are then restored to the target server. The SMK and DMK are totally separate and not required. If the target server does not have a DMK then create one before restoring the certificate, but it's not required from the source server and indeed probably best if it's not for security reasons 😉
See my guide at this link[/url] for moving a TDE protected database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉