As said, the thing that really changes is the jump from 32 bit OS to the 64 Bit world. Everyone here has had to go through this over the last couple of years so your not alone. So there is plenty of help sorting out the odd issue in the X series forum which is the main forum. As cook said, mostly it's plug ins that change. The software still maintains the same stuff it always did, record audio and midi. Lots of big improvements so you'll be happy with those changes.
Try the free demo first if your not sure. It will take at least a week to feel comfortable again.
I was also going to mention it's a good idea to have all your old projects saved as CWP files and not Bundles. CWB files are often trouble makers when opening them in the newer versions. But CWP files will always open, even if it has to be in Safe Mode.
I've opened old ( 2006) Home studio files without too much trouble in X3 Studio. They are all CWP files with standard issue Cakewalk plug ins used. It will just warn you that they might sound different.
I've had more issues with projects that were recorded at a different clock rates. Those the audio tracks will be blank until you convert them.