I need migrate foxpro database into SQL express 2012. Now one PC (win7) working as a server and another person is connected to it. I'm thinking about some separate box for SQL instance and two clients will be connected to it.
Based on your experience what I should choose for hardware:
- win 7 pro powerful workstation
-some simple server with windows 2008 r2
Only two people will be connected to this machine and working with database. Not sure if is any reason to spend money on server if workstation can handle it.
I'm planning install SQL server 2012 express.
By the way, database is not very big, after conversion should be around 1GB.
thanks for any comments