I need a suggestion or a best practice for my migration.
Windows 2008 64bit
DB on SQL 2005 Sp4
Windows 2008 R2 64bit
DB on SQL 2012
I preferred to do a fresh install. I completed the migration (policies, tasks, and others settings).
Now I just have to move clients (1000~).
a) Registered new server on old server, export and import security key and use KB79283 and "TRANSFER" option for move all clients
b) Re-push agent on all clients (with force installation option)
Which is the best option?
But from my perspective, why repush the agent, when you can just transfer?
So I'd do a) then complete with b) if you have stragglers.
A big plus of a) is clients don't need to be online at the same time you're pushing. So for things to happen "hand off", a) is best