Azure SQL数据库开发环境

对此的主要警告是要了解内部部署SQL Server中可用的功能，而这些功能在Azure SQL中不可用(例如，列存储索引仅在Azure SQL的高级层中可用，而在SQL Server中没有SQL代理)Azure SQL，). 链接: SQL Server下载: https://www.microsoft.com/zh-cn/sql-server/sql-server-downloads 功能奇偶校验: https://blogs.msdn.microsoft.com/azureedu/2016/07/15/what-features-are-not-supported-in-azure-sql-database/ https://docs.microsoft.com/en-us/azure/sql-database/sql-database-transact-sql-information 正如另一位用户评论的那样，您可以将Dev和Staging数据库放入一个Elastic Pool中，但是目前最便宜的Elastic Pool是每月$ 75.如果您必须在Azure中拥有DEV数据库，则最便宜的选择就是使其成为基本层，每月仅需$ 5.不确定预算是多少，但从技术上讲，将数据库放入VM也不是Azure SQL-它是Azure VM上的本地SQL Server，然后它将与本地安装具有功能奇偶性(当然，前提是您的本地安装安装与SQL Server的版本相同.How can I setup SQL Azure Database for development. I currently have few SQL databases ProjectName-Development, ProjectName-Staging, ProjectName-Production ...Is this the right way? This is getting more and more expensive. 解决方案 I would recommend (from experience) using Azure only for Staging and Production environments. SQL Server 2016 Developer Edition is free (so is SSMS) so you can do all of your local development ... locally. When you're ready to go to staging, you can then perform a schema compare via your database project (assuming you have one...if not, you should probably create one) and push the schema up to the Azure DB.The main caveat to this is to be aware of the features that are available in on-premise SQL Server that are NOT available in Azure SQL (e.g. columnstore indexes are only available on the Premium Tier of Azure SQL, no SQL Agent in Azure SQL, tec.).Links:SQL Server Download:https://www.microsoft.com/en-us/sql-server/sql-server-downloadsFeature Parity:https://blogs.msdn.microsoft.com/azureedu/2016/07/15/what-features-are-not-supported-in-azure-sql-database/https://docs.microsoft.com/en-us/azure/sql-database/sql-database-transact-sql-informationEdit: As another user commented, you could put your Dev and Staging DBs in an Elastic Pool, but the cheapest Elastic Pool is ~$75/month currently. If you MUST have your DEV database in Azure, your cheapest option is to just make it a Basic tier for $5/month. Not sure what your budget is, but also putting the DBs in a VM is not technically Azure SQL then - it is On-Prem SQL Server on an Azure VM, which will then have feature parity with your local install (of course provided your local install is the same version of SQL Server). 这篇关于Azure SQL数据库开发环境的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！