I am investigating the process involved in converting an existing Access 2010 application to sql server. This would be a front end access and back end SQL server configuration on a local Win 7 machine with home networking, not a server.
In doing so, I wanted to ask the following before going too much further.
1. Which version of SQL Server do I download? Is it the Express with Tools, Local DB, Express Only? Why?
2. After installation, is there something I can use to migrate all my tables, I heard of some migration tool. Is that right?