离线开发SQL Azure [英] Developing for SQL Azure offline

问题描述

这可能是一个愚蠢的问题，但是我想开始将几个Web应用程序迁移到Azure.我没有对它们做任何特别困难的事情，并且到目前为止，除了一件事情之外，我已经解决了我所有的开发问题(部署是另一种蠕虫病毒).我如何在不连接天蓝色的情况下处理这些项目?也就是说，我经常在恐怖或根本不存在wifi的地方工作.如何设置内容，以便在无法连接到云中的SQL Azure时仍可以使用数据库?目前，我没有使用Azure表存储或任何其他东西，只是使用普通的旧SQL，尽管我认为有几件可以从表存储或Blob存储中受益.使不连贯的开发变得轻松的最佳方法是什么?

This is probably a stupid question, but I'd like to start moving a couple of web apps over to azure. I'm not doing anything particularly difficult in them and have solved all of my development concerns (deployment is another can of worms) so far except for one thing. How do I work on these projects without connecting to azure? That is, I frequently work in places with wifi that is flat out horrid or non-existent. How do I set things up so I can still work against a database if I cannot connect to SQL Azure in the cloud? Currently I'm not using azure table storage or anything, just plain old SQL, although I have a few pieces that I think would benefit from table storage or blob storage. What's the best way to make disconnected development painless?

推荐答案

Azure SDK 包括各种服务的本地版本，因此您可以从一开始就脱机工作. SQL Azure本质上是具有某些限制的SQL Server，因此您可以针对本地版本的SQL Server Express进行编程.

The Azure SDK includes local versions of the various services so you can work offline from the start. SQL Azure is essentially SQL Server with some limitations, so you can program against a local version of SQL Server Express.

仅在必须将应用程序部署到Azure时才需要连接.

You only need a connection when you have to deploy your application to Azure.

如果您选中"入门 "教程，您将看到针对localhost的开发已完成.该网站将被部署到Azure中，只有当你选择发布网站".

If you check the "Getting Started" tutorial, you'll see that development is done against localhost. The site is deployed to Azure only when you select "Publish Web Site".

一个更好的教程是"将具有成员资格，OAuth和SQL数据库的安全ASP.NET MVC应用程序部署到Windows Azure网站"，其中包括将数据库发布到Azure.

An even better tutorial is "Deploy a Secure ASP.NET MVC app with Membership, OAuth, and SQL Database to a Windows Azure Web Site" which includes publishing a database to Azure.

在创建数据部署脚本"部分中，本教程使用安装在本地计算机上的SQL Server Express实例.

In the "Create a Data Deployment Script" section, the tutorial uses the instance of SQL Server Express installed on the local machine.

我认为需要重复， SQL Azure不是必须在本地安装的特殊数据库.实际上是SQL Server，这意味着您可以正确使用相同的代码，并对SQL Server和SQL Azure使用相同的工具.

I think it needs repeating, SQL Azure is NOT a special database that has to be installed locally. It is actually SQL Server which means you can right the exact same code and use the same tools for SQL Server and SQL Azure.

您可以简单地使用SQL Server Express创建可与SQL Azure一起使用的程序

You can simply use SQL Server Express to create programs that work with SQL Azure

这篇关于离线开发SQL Azure的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！