Moving SIMS to new server
I want to move our SIMS to a new server as the old server is so old and slow. Also will be replacing my SIMS workstations, so basically, starting from scratch. I've done this before when SQL version was 2005 following excellent instruction from | SiX | Somerset Internet Exchange |. The existing server has recently been upgraded to SQL2008 so can't use these notes. I've tried in a test enviroment to setup but getting errors on the DBattach phase - Error ASSEMBLY dznet Does not exist, Please Run SIMSSQLApplicationSetup.exe.
I've started off by running the SIMS-FMS SQL2008.exe file, followed on screen prompts and changed the path to f:\program files\microsoft sql server etc.
Anyone done a move to new server using sql2008 and can point me in the right direction.