VM上的Azure SQL Server可以作为生产数据库吗? [英] Can Azure SQL Server on VM be the production database?
问题描述
我正在尝试弄清VM上的Azure SQL Server与Azure SQL Server数据库之间的区别.我知道一个是IaaS，另一个是PaaS服务.但是有一件事我仍然不明白，哪个可以用于开发/测试，哪个可以用于生产?还是两者都具有这种功能?
I am trying to figure out the difference between Azure SQL Server on VM and the Azure SQL Server database. I know one is IaaS and another is a PaaS Service. But there is one thing I still don't understand that which one could use for Dev/test and which one could use for production? or both of them have such capabilities?
以我的理解.VM上的Azure SQL Server仅用于开发/测试，如果需要投入生产，则需要使用Azure SQL Server数据库.因此，我需要将数据从VM传输到SQL数据库.我对么?
As my understanding. The Azure SQL Server on VM is only for the Dev/test, if you need to go production, need to use Azure SQL server database. So I need to transfer my data from VM to the SQL Database. Am I correct?
推荐答案
就像尼克·麦克德迈德(Nick McDermaid)所提到的那样，没有任何内容表明VM上的SQLServer仅用于开发和测试.
Like Nick McDermaid mentions, there isn't anything that states SQLServer on VM is only for Dev and Test.
here is the info on this space from Microsoft- https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas
生产总是很难.使用托管服务使维护和操作服务变得更加轻松，而只需由服务提供商来执行，而不是您扮演角色.
Production is always hard. Using a Managed Service makes life easier at the job of maintaining and operating it is with the service provider instead of you performing the role.
我将始终为开发和生产工作负载选择IaaS版本上的托管服务(在本例中为Azure SQL PaaS服务).
I would always choose a Managed Service (in this case Azure SQL PaaS Service) over the IaaS version for both Dev and Production workloads.
这篇关于VM上的Azure SQL Server可以作为生产数据库吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
