Skip Navigation LinksHome Page > SQL Azure Information Center > SQL Azure Downloads

Downloads for Access, SQL Azure, and SQL Server




A SQL Server Driver must be installed!

An ODBC driver is required for all computers that use Microsoft Access and Azure SQL Databases. The recomended drivers are the Microsoft® ODBC Driver 11 for SQL Server® for Windows or the Microsoft® SQL Server® 2012 Native Client. Microsoft no longer includes the necessary drivers with Windows. They are only included if you have installed SQL Server 2012 or 2014 on your computer.

Instructions for Using the Microsoft ODBC Driver 11 for SQL Server for Windows:
1. First download and install the Microsoft ODBC Driver 11 for SQL Server for Windows. Instructions are below.
2. Then change the Driver section of your Connection String to DRIVER=ODBC Driver 11 for SQL Server;.

--Supported Operating Systems: Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2012, Windows Vista Service Pack 2.
--Supports Microsoft SQL Server 2005, 2008, 2008 R2, SQL Server 2012, SQL Server 2014 and Windows Azure SQL Database.

Install Instructions for Microsoft ODBC Driver 11 for SQL Server for Windows
1) Click the "Download" button on .
2) Select the download file to match your computer's Windows Operating System.
        For 64 bit (x64) Operating Systems select the 1033\x64\msodbcsql.msi file.
        For 32 bit (x86) Operating Systems select the 1033\x86\msodbcsql.msi file.

The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Windows Azure SQL Database. It contains new features as well as all the features that shipped with ODBC in SQL Server 2012 Native Client.

Introducing the new Microsoft ODBC Drivers for SQL Server
Welcome to the Microsoft ODBC Driver 11 for SQL Server on Windows
Driver-Aware Connection Pooling in the ODBC Driver for SQL Server


Instructions for Using the Microsoft SQL Server 2012 Native Client:
1. First Download the Microsoft® SQL Server® 2012 Native Client from the Microsoft® SQL Server® 2012 Feature Pack Download page Instructions on how to do this are below.
2. Then change the Driver section of your Connection String to DRIVER={SQL Server Native Client 11.0};.

--Supported Operating Systems: Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Vista Service Pack 2.
--Supports Microsoft SQL Server 2005, 2008, 2008 R2, SQL Server 2012 and Windows Azure SQL Database.

Install Instructions for the Microsoft SQL Server 2012 Native Client
1) Click the "Install Instructions" button on the Microsoft® SQL Server® 2012 Feature Pack Download page.
2) Scroll down the page until you see "Microsoft® SQL Server® 2012 Native Client".
3) Select the download file to match your computer's Windows Operating System.
        For 64 bit (x64) Windows Operating Systems select the X64 Package (sqlncli.msi).
        For 32 bit (x86) Windows Operating Systems select the X86 Package (sqlncli.msi).

More Information:
Learning SQL Server Native Client
Using Connection String Keywords with SQL Server Native Client
Updating an Application to SQL Server Native Client from MDAC
Building Applications with SQL Server Native Client
System Requirements, Installation, and Driver Files
SQL Server Native Client Programming






Free Demonstration Application

The free Demonstration Application uses an Azure SQL Database as a back end. It shows a little of what can be done with Access and SQL Azure. You must install the Microsoft ODBC Driver 11 for SQL Server on Windows for the Demonstration Application to work. It was formerly known as the SQL Server Native Client (SNAC). Links to the download are above. It is important to read the ReadMeFirst and the Release Notes files before using the application.
Version 1.6.2 for Access 2010, 2013
Version 1.6.2 for Access 2007




Access Runtime Versions

The Access Runtime Versions are Free

Access 2007 Download: Access Runtime
The Microsoft Office Access 2007 Runtime enables you to distribute Access 2007 applications to users who do not have the full version of Access 2007 installed on their computers.

Access 2007 Runtime and Developer Extensions
Now available as free downloads. The Access 2007 Developer Extensions provide packaging and deployment tools and licensing and distribution agreements to make it easier for developers to deliver applications. The Microsoft Office Access 2007 Runtime enables you to distribute Access 2007 applications to users who do not have the full version of Access 2007 installed on their computers.

Microsoft Access 2010 Runtime Download page
The Microsoft Access 2010 Runtime enables you to distribute Access 2010 applications to users who do not have the full version of Access 2010 installed on their computers.

Access 2010 Runtime Service Pack 1
The Microsoft Access 2010 Runtime Service Pack 1 (SP1) provides the latest updates for Microsoft Access 2010 Runtime.

Download Access 2010 Runtime, Database Engine Redistributable and Source Code Control
Download the Access 2010 Runtime, Access Database Engine Redistributable (office connectivity components) 2010 and Source Code Control Add-in for Access 2010.

Download the Access 2013 Runtime
The Microsoft Office Access 2013 Runtime enables you to distribute Access 2013 applications to users who do not have the full version of Access 2013 installed on their computers.




Databases

SQL Server and Cloud Platforms
The foundation of Microsoft’s comprehensive data platform, SQL Server delivers breakthrough performance for mission-critical applications, using in-memory technologies, faster insights from any data to any user in familiar tools like Excel, and a resilient platform for building, deploying, and managing solutions that span on-premises and cloud.

Download SQL Server 2014 Express
Download and install Microsoft's Free edition of SQL Server with 10 GB of database storage. You can also download SQL Server Express with tools.




Migration Tools

Download the Microsoft SQL Server Migration Assistant v5.3 for Access
SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Access to SQL Server. SSMA for Access automates conversion of Microsoft Access database objects to SQL Server database objects, loads the objects into SQL Server, and then migrates data from Microsoft Access to SQL Server.

SSMA for Access v5.3 is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.

Note: If you are using 32 bit Access you need to open the SSMA using the Start Menu. The shortcut that is installed on the desktop is for 64 bit Access only.

Microsoft SQL Server Migration Assistant for Access(AccessToSQL)
Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005 / Microsoft SQL Server 2008 / Microsoft SQL Server 2012 / MicrosoftSQL Server 2014 / Microsoft SQL Azure. SSMA for Access converts Access database objects to SQL Server or SQL Azure database objects, loads those objects into SQL Server or SQL Azure, and then migrates data from Access to SQL Server or SQL Azure.

This documentation introduces you to SSMA for Access, provides step-by-step instructions for migrating Access databases to SQL Server or SQL Azure, and provides information about issues that might occur after migration.

Move Access Data to the Cloud Using the SQL Server Migration Assistant
Microsoft SQL Server Migration Assistant for Access allows you to move your Microsoft Access tables and queries to Windows Azure SQL Database. This article will walk through how to use the tool to move the NorthWind database to SQL Database.

Two editions of the SSMA are installed. You use the 32 bit edition if you have 32 bit Access and the 64 bit edition if you have the 64 bit edition of Access.

SQL Database Migration Wizard v3.9.17, v4.0.20 and v5.0.1
A CodePlex Project, the SQL Database Migration Wizard (SQLAzureMW) is designed to help you migrate your SQL Server 2005/2008/2012 databases to Azure SQL Database.




Tools and Add-ins

SQL Data Sync is supported in the new HTML portal You can now leverage SQL Data Sync Services from within the new Windows Azure Management Portal. SQL Data Sync lets you synchronize data between multiple SQL databases. These SQL databases can span across your on-premises environment and the cloud, or across multiple cloud hosted databases (for example: within multiple Windows Azure regions around the world). It is a very powerful capability that can enable a variety of interesting scenarios.

SQL Azure Data Sync Agent Preview
This download is for the on-premises Data Sync Agent that works in conjunction with the SQL Azure Data Sync service. It enables on-premises SQL Server data to be synchronized with SQL Azure databases.

Microsoft® SQL Server® 2014 Feature Pack
The Microsoft SQL Server 2014 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft SQL Server.

Enzo Backup for SQL Azure
Enzo Backup enables you to backup a SQL Azure database and restore the backup to other SQL Azure databases or an on premise SQL Server databases. You can also schedule backup jobs. Developed by Herve Roggero, Microsoft SQL Azure MVP (Most Valuable Professional) and co-author of Pro SQL Azure from APress.

BCP2SQLAzure: Free tool to import/export data between SQL Azure and SQL Server.
SQL Azure BCP makes it easier for database admins and developers to do bulk copy loads into SQL Azure. This bcp replacement allows you to define each load using an easily XML file. It´s developed using C#. SQL Azure BCP is a CodePlex Project.

Microsoft Sync Framework Developer Center
Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline access for applications, services, and devices with support for any data type, any data store, any transfer protocol, and any network topology.

Free Tool Azure SQL Database Backup.
Free backup and restore for Azure SQL databases. Backup on-premise or to Azure BLOB storage.

SSMS Tools Pack
A very popular free add-in for Microsoft SQL Server Management Studio with a number of useful features including CRUD stored procedure script generation.



Login Status: Not logged in.
Login      Free Registration

  Call Us for a Free Consultation

Phone:

Email:

Share

Site Navigation

Skip Navigation Links.