I have an SQL database on one computer and would like 2-5 other computers in the same room to be able to access that database and run routines on its records simultaneously. Maintaining speed and reliability are crucial. The individual routines could take days or weeks to run.
The SQL database PC, while having a constant internet connection and downloading and importing data will not have any other internet traffic, no hosting or anything like that.
Does this SQL PC have to be a full-blown server for this to work? Or can it be a Windows 10 system? My very limited experience is that back in the old days, while windows systems in the same office or home network could be pointed to each other, the connections were not very reliable. And I would hate to have the system(s) built only to find that the connections were failing or that the speed was crippled.
Any advice would be a big help. Thank you.
The SQL database PC, while having a constant internet connection and downloading and importing data will not have any other internet traffic, no hosting or anything like that.
Does this SQL PC have to be a full-blown server for this to work? Or can it be a Windows 10 system? My very limited experience is that back in the old days, while windows systems in the same office or home network could be pointed to each other, the connections were not very reliable. And I would hate to have the system(s) built only to find that the connections were failing or that the speed was crippled.
Any advice would be a big help. Thank you.