Microsoft SQL Server Migration Conversion and Upsizing
Many
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?
While 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
We 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?
FMS
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.
Contact us to discuss your needs with
the world's
Access to SQL Server Upsizing experts.