I am the IT for a clinic and I am looking to upgrade the server from SQL 2012 Express (x86) to SQL 2012 x64 standard to fix some speed and reliability issues. Luckily the office is closed for the next four days so I have time to get this done, finally, but other than references I can't really find any instructions for doing this.
I know how to upgrade SQL Express as I have done it before, but I just want to make sure I preserve the data properly.
Wait, what are the speed and reliability issues, what version of AC how big is the practice and how many charts? All of these may be issues that may effect reliability and the real question is: Do you need x64?
One version of what James has put above would be to put it on another machine (VM) and install AC which will install x64 SQL light if it is a 64 bit machine (I believe, correct me if I'm wrong please). Then do a backup restore. You may need to talk to AC support to get a license number (depending on version of AC) which cannot be done on the weekend.
This should go smoothly IFF you are using the same version AND you have the correct key, if needed (version 9) AND there is not another issue with the database. That's a lot of ANDs and one big IFF.
