Azure的网站使用虚拟机上运行的SQL Server？ [英] Azure Websites to use a VM running SQL Server?

问题描述

我想添加一些我的网站天青的，但他们依靠目前没有在SQL Azure中支持SQL Server的全文搜索。

I want to add some of my websites to Azure, however they rely upon SQL Server's full text search which currently isn't supported in SQL Azure.

有没有办法在Azure中创建一个虚拟机，安装SQL Server，然后更改为使用SQL Server实例的网站连接字符串？我显然想要安全地做到这一点，并用尽可能少的网络延迟。

Is there any way to create a VM in Azure, install SQL Server and then change the website connection string to use that SQL Server instance? I would obviously want to do this securely, and with the least possible network latency.

我要使用Azure的网站功能，并有那些网站的访问的Azure虚拟机内部运行的SQL Server实例。

I want to use the Azure websites functionality and have those websites access a SQL Server instance running inside an Azure VM.

推荐答案

SQL Azure的数据库不支持全文搜索呢。

Azure SQL Databases doesn't support Full Text Search yet.

使用Azure的新的的Azure虚拟机的发布，您可能需要在Windows Server（无论是2008卢比或2012年），然后安装你羽翼丰满的SQL Server 2008 R2或2012年（全文搜索 - 即普通/非云的SQL Server）。

With Azure's new release of Azure Virtual Machines, you may take Windows Server (either 2008 Rs or 2012) and then install your full fledged SQL Server 2008 R2 or 2012 (with full text search - i.e. regular / non cloud SQL Server).

一旦部署在SQL Server，它几乎就像你传统的SQL Server在自己的服务器上运行。你管理所有的传入端口，防火墙规则等。使用连接字符串分贝您的网站整合。

Once you have deployed the SQL Server, it is almost like your traditional SQL Server running in your own Server. You manage all the incoming ports, firewall rules etc. Use the connection string to integrate the db in your website.

这篇关于Azure的网站使用虚拟机上运行的SQL Server？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！