Azure SQL数据库开发环境 [英] Azure SQL Database Development Environment
问题描述
如何设置SQL Azure数据库进行开发.我目前只有几个SQL数据库ProjectName-Development，ProjectName-Staging，ProjectName-Production ...
这是正确的方法吗?这越来越贵了.
我建议(根据经验)仅将Azure用于登台和生产环境.SQL Server 2016 Developer Edition是免费的(SSMS也是免费的)，因此您可以在本地进行所有本地开发.准备好进行过渡时，您可以通过数据库项目执行架构比较(假设您有一个...如果没有，则应该创建一个)，然后将架构推入Azure DB.
对此的主要警告是要了解内部部署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-downloads
Feature 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-information
Edit: 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数据库开发环境的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
