Skip to content

Access Database to SQL Server upgrade

For this project, Datawise was contracted to take an existing set of related Microsoft Access databases and upgrade them so that they a modern version of Microsoft Access and move the actual data into a fast, and reliable Microsoft SQL Server database.

Jason Cook

The databases were varied in function and covered a number of different crucial parts of the business. Due to the complexity of the databases and the fact that Datawise was not involved in the original creation of applications, this was a challenging project and require analysis, design, data migration and troubleshooting skills.

In addition, many features of the database applications were enhanced during the process. A number of subsequent additions involved enhanced reports, new streamlined features, and integration with external system, one such integration being a cloud-based service that processes input data and returns results back to the local database for long term storage, production usage and reporting.

Custom software for business on a budget.
The Importance of Social Media