FMS has extensive resources and experience to help you migrate Microsoft Access applications to SQL Server. In fact, we were selected by the Microsoft SQL Server team to lead a national campaign to promote Microsoft Access to SQL Server upsizing and write technical papers they've posted on MSDN.
Microsoft Access is a wonderful platform that empowers information workers and professional developers to create powerful solutions on the Windows desktop. Over time, good applications evolve and become more mission critical. At some point, you begin to consider migrating your Access application to a more powerful database platform. It could be based on scalability, security, the need for a web solution, legal requirements, performance, or a variety of other reasons. When that time comes, a natural option is Microsoft SQL Server.
There are several options for hosting SQL Server databases:
There are many ways to upsize your Microsoft Access databases to SQL Server:
Here are some of the whitepapers we've written to help you make the right decision about converting and migrating Access databases to SQL Server.
This panel explores the different reasons, approaches, and challenges of migrating applications to Microsoft SQL Server. Taped May 2009 in Los Angeles, CA (43 minutes)
Microsoft’s Dr. Zhiming Xue interviews Luke Chung, founder and president of FMS, on dealing with Microsoft Access database solutions and the challenges project teams face when migrating them to more scalable platforms. (22 minutes)
Not all Access databases should or will migrate to SQL Server. FMS offers a wide range of Access products to help you enhance and maintain your Access databases. Here are a few to help system administrators and database administrators better manage Access databases across a network or enterprise:
Our Professional Solutions Group offers consulting services to migrate your existing Microsoft Access databases to SQL Server. Our experienced staff has upsized Access databases to maximize your existing investment, take advantage of SQL Server's features, and minimize costs. Whether it's a simple data upsizing to a complete rewrite of the application to Microsoft .NET or SharePoint, we can help with our world class Microsoft Access and Visual Studio experts on ASP.NET, C#, and VB.NET.
Learn more about our:
Headquartered in Tysons Corner in Northern Virginia, FMS has completed Access to SQL Upsizing projects and general programming services for commercial and government organization across the country from Alaska to California to Florida to New England. Of course, many of our customers are located locally in the Washington DC metropolitan region including Virginia and Maryland. Contact us today to discuss your needs.