We currently run SQL Server 2008R2 on a Windows 7 computer with 16GB of RAM and are being forced to upgrade as the Access SQL Server Migration Assistant no longer works with 2008R2.
I plan to purchase SQL Server 2017 Standard and would like to get suggestions as to what type of desktop hardware we will need and how much trouble I will have if I purchase a new machine and attach it to our network as a workstation, and then try to install 2017 Standard on the new machine, and then move the existing files through the LAN to the new machine.
My computer consultant told me all we need is a Windows 10 Pro machine for our application.. in addition to how much trouble it will be to get 2017 to work with 2008R2 files, what type of hardware do you recommend for the new machine if we attach it as a workstation.
By hardware I mean... would an i7 processor with 32MB and a 10T drive be a good choice? I am confused because I was expecting to need a raid mirror drives, but don't seem to see many companies selling hardware configured this way.
The SQL Server machine would be used exclusively on on our LAN as the BE for MS Access.