Microsoft SQL Server Migration Conversion and Upsizing

Microsoft Access to SQL Server UpsizingMany Microsoft Access databases evolve over time to become mission critical applications. At some point, you may find the need to migrate your application or the data to a more robust, scalable, and secure platform such as SQL Server.

Why Migrate to Microsoft SQL Server?

Microsoft SQL ServerWhile many MS Access applications can continue to operate unmodified, some need to share its data with other applications, especially web sites. As requirements for availability, security, and scalability increase, they push the limits of Access. The natural choice for many organizations is to migrate to SQL Server.

Microsoft SQL Server is a great choice for nearly all application data. It scales to hundreds of users and can serve data for Windows and web applications, web services, and a variety of architectures.

Migrating to SQL Server in the Cloud with SQL Azure

Microsoft Access and SQL Azure DatabasesWe are also experienced with using the Microsoft SQL Azure cloud platform for migrating your MS Access applications. Have Microsoft host your SQL Server database starting at $10 a month with no additional licensing or hardware fees. Read our paper on Microsoft Access and Cloud Computing with SQL Azure Databases (Linking to SQL Server Tables in the Cloud) for more details.

Maximizing Your Existing Investment in Microsoft Access

We at FMS can help you with this transition so that you maximize your existing investment in Microsoft Access while taking advantage of the many benefits of SQL Server. Depending on your needs, we may:

  • Optimize the Access database with our Best Practices to avoid a need to move it to another platform. This may address performance, multiuser, system administration, and maintenance support issues, and allow the Access application to live longer.
  • Migrate the data from an Access/Jet database to SQL Server while maintaining the front-end Access database with all its forms, reports, and code. This takes advantage of all the features of the SQL Server data storage while letting you keep your existing investments, especially reports.
  • Creating a hybrid solution so that an external web solution is created for a portion of the functionality while internal users continue to use Access.
  • Taking advantage of Microsoft SQL Azure to migrate your data to the cloud at an exceptionally low cost for Microsoft to manage this. We can then extend the application with a .NET solution created on Windows Azure for the general public internet site while keeping your Access solution for internal needs.
  • A complete rewrite, re-architecture and migration to a .NET and SQL Server solution.

We'll work with you to determine the correct approach to address your needs both short and long term.

Why Trust FMS to Help you Migrate to SQL Server?

Microsoft Gold Certified PartnerFMS has extensive experience creating and enhancing Access applications, and upsizing them to SQL Server. FMS was selected by Microsoft to write several papers on this topic which are featured on the MSDN web site. Microsoft also chose FMS to lead a nationwide seminar on Access to SQL Server Upsizing.

FMS is also a leader in migrating Microsoft Access applications to the Microsoft Azure platform. So if you're interested in Cloud Computing, FMS can help.

FMS is simply the best choice to upsize your Access databases to SQL Server. Our history as the world leader in Microsoft Access development makes us uniquely positioned to help you migrate to SQL Server. With our extensive experience, we know how to complete your project the right way and do it at a very competitive price.

FMS at Microsoft TechEd Conference

Luke Chung, President of FMS, was selected by Microsoft to participate on a panel discussion on this topic. Watch the Access to SQL Server Upsizing video from the Microsoft TechEd Conference in Orlando, Florida.

Read our whitepapers and browse FMS authored resources on Microsoft's website to learn more about upsizing your Access databases to SQL Server.

Contact Us Today

Let us help you determine what you need to do and how to do it.

Risk Free Assessment

Contact us to discuss your needs with the world's Access to SQL Server Upsizing experts.