Hi everyone,
I've been tasked to migrate our Access solution's data to SQL Server in which we will continue to use Access for the frontend. I would like to draft a document that describes the approach, order of steps to be taken and accomplished besides the actual transfer of data such as logins, roles, authentication, reprogramming of the application where needed and such general ideas. I used to do a lot of SQL Server development in the nineties in tandem with Visual Basic. So it's been a while. I bought four books on SQL Server to freshen up my knowledge.
Any advice on this document? No has asked me to provide it. I just thought this would be a good idea to help add confidence that this project is being properly attended to and not just slapped together haphazardly.