I want to use a SQL database for an application I'm writing. It was using an Access database, but the database will eventually collapse (a fairly long time from now) because the size will eventually be too large for an Access database. So, we want to move over to SQL before that happens. Originally, the usage was that there was a database of x-rays with all the identifying information. The software just read out of that database to open selected x-rays. We just want to make that Access database into a SQL database. However, I've never used SQL before. I started writing code in MSVS C# 2005 Pro edition using the .NET Framework and the System.Data.Sql namespace. Now, if I write code with that, will each client computer now have to have an SQL Server on their system? The application will be the only thing accessing that database and it'll never be accessed over the network.
So, the main question is, "will an installation of a SQL server be absolutely required on each client system with the application?" If I do need a SQL Server installed on each machine, would I be allowed to install MS Sql Server 2005 Express edition on each machine or would that be against the licensing (i never understand EULAs)?
A secondary question is just asking if anybody knows of any good references for using the System.Data.Sql namespace to write a project and also any good references for anything else related to SQL that I should know.