Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm developing/testing a .NET application which needs to access a live SQL Azure instance. (Yes, it has to be an Azure instance, because it's using code that's specific to Azure, not just SqlClient stuff.)

In order to prevent accidental data changes, I'd prefer to run the application against a local instance rather than the live one.

Copying the schema/data is another issue, but as long as I can execute SQL against the local instance, I can take care of it.

Is it possible to run SQL Azure on my local development machine?

(I'm using Windows 7, but can move to Windows Server if necessary.)

share|improve this question
This might help:… . What is it about the SQL side of things that is Azure specific? – Kev Oct 9 '11 at 23:52
up vote 2 down vote accepted

What you want to do isn't possible at this time.

Microsoft recommends using SQL Server 2008 in place of SQL Azure for development purposes. You can use any version (Enterprise, Standard, Express). The majority of the functionality is the same but there are some key differences you need to know when migrating, which can be found here:

If you're doing something that REALLY needs SQL Azure, and the other versions of SQL Server just don't cut it, your only other option would be to provision a separate database instance from Azure and create a firewall rule to allow your development environment access to it.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.