Database Migration / MS Access / SQL

Company: SGS Technologie
Location: Sanford
Posted on: March 26, 2020

Job Description:

SGS Technologie, LLC is a leading software development and IT staffing firm headquartered in Jacksonville, FL. Founded in 2003, SGS specializes in application and database development, contracting help desk and technical support professionals, and contract-to-hire and full-time positions. Since our inception, we have been committed to creating long-term business relationships with our employees and clients while excelling in customer service. Title Database Migration MS AccessSQL DBA Location Sanford, FL Contract Objective Storing data within Microsoft Access has presented a variety of issues that expose the data to corruption and loss. These issues are a result of the Microsoft Access data storage limitations. Two primary concerns are the 2-gigabyte data limit and unstable multi-user data storage. The client looking for a contractor to migrate the backend data storage functionality of existing Access 2007 applications to a Microsoft SQL Server database and an updated version of MS Access. Since Microsoft SQL data storage doesnrsquot have the limitations described above, we are expecting a significant increase in data integrity and a more manageable environment. The contractor shall ensure that the new SQL database integration works seamlessly with the existing Access applicationrsquos user interface. From the userrsquos perspective, the existing application must continue to function as it did prior to the migration. Scope of work The contractor is responsible for migrating Access databases and applications without impacting existing forms, reports, and queries, etc. The contractor must perform quality control testing to ensure the application works properly after implementing the modifications. If the project includes the use of any freeware or open-source functionality, it must be identified in the proposal. If the Access database contains links to external files, the files need to be imported into the MS SQL database replacing the links. An example of this is external PDF files that are currently stored in folders. It is expected that the implementation of these files might have some minimal impact on the user interface. If the contractor encounters significant issues with the Access database design or data, the contractor must propose options to the IS Project Manager to resolve the issues. The contractor must also identify the significance of the issue along with any impact it might have on the proposed cost and delivery timeframe. The IS Project Manager must approve the proposed changes before they are implemented. Making any modification to simplify or improve the database is otherwise outside the scope of this project. Thanks, Sruthi Sruthisgstechie.com (904) 606-5330

Keywords: SGS Technologie, Gainesville , Database Migration / MS Access / SQL, IT / Software / Systems , Sanford, Florida