Link to home
Start Free TrialLog in
Avatar of chrislindsay
chrislindsayFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Migrating Microsoft SQL Server instance 32 bit to 64 bit machine

Hi Experts,
I am a system admin and I would like to migrate a 32 bit version of sql server 2008 standard to a 64 bit version (New Hardware) due to the sunsetting of existing hardware.  
What is the best way of doing this avoiding the pitfalls?

Thanks in advance
SOLUTION
Avatar of Ephraim Wangoya
Ephraim Wangoya
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chrislindsay

ASKER

Hi what about all the jobs \ security settings etc.  Is it a matter of migrating all the components manually ?
Is there no migration tool?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
All good partial solutions.  Thanks