We use a Microsoft SQL Server-powered system in our small family business. This is our main retail system.
我们在我们的小型家族企业中使用微软的SQL server支持系统。这是我们的主要零售系统。
I am sick and tired of running a server in-house and the business cannot afford a hosted (remote) SQL Server solution. The family business is a small, stable but not (yet) rapidly-growing retailer so does not have a serious budget for technology.
我已经厌倦了在内部运行服务器,企业无法负担托管(远程)SQL服务器解决方案。家族企业规模小、稳定,但还没有快速增长的零售商,因此在技术方面没有足够的预算。
Looking at Google's new cloud-based SQL service, I see it is mySQL not SQL Server.
查看谷歌新的基于云的SQL服务,我发现它是mySQL而不是SQL Server。
Does anyone know of a driver etc. to make mySQL look like SQL Server?
有没有人知道一个驱动程序,让mySQL看起来像SQL Server?
Then our in-store system could use cloud-based mySQL as if it were SQL Server and we could stop worrying about backups, servers, up-time etc.
然后我们的存储系统可以使用基于云的mySQL,就好像它是SQL Server一样,我们可以不再担心备份、服务器、正常运行时间等问题。
We could then use the time saved to earn enough revenue to pay for a hosted solution!
然后我们可以利用节省下来的时间来获得足够的收入来支付托管解决方案!
2 个解决方案
#1
3
I don't know about a translator either. However, did you look at one of the managed database services for SQL Server out there like SQL Azure or Amazon RDS.
我也不认识翻译。但是,您是否查看过SQL Server的托管数据库服务,比如SQL Azure或Amazon RDS。
SQL Server Azure (http://msdn.microsoft.com/en-us/library/windowsazure/ee336279.aspx) is not completely compatible to a full SQL Server installation but it gets close.
SQL Server Azure (http://msdn.microsoft.com/en-us/library/windowsazure/ee336279.aspx)与完整的SQL服务器安装并不完全兼容,但已经很接近了。
Amazon's Relational Database Service (https://aws.amazon.com/rds/) lets you select between MySQL, Oracle and SQL Server. It is running the full SQL Server under the covers but has a few restrictions too.
Amazon的关系数据库服务(https://aws.amazon.com/rds/)允许您在MySQL、Oracle和SQL Server之间进行选择。它在后台运行完整的SQL服务器,但也有一些限制。
Both services allow you to not have to worry about hosting the server itself. However, database maintenance like backups, index maintenance and some performance tuning is still up to you.
这两个服务都允许您不必担心托管服务器本身。但是,数据库维护(如备份、索引维护和一些性能调优)仍然取决于您。
#2
1
In short, no. For more detail on the differences.... At the end of the day, there would be a fair amount of work making sure it would work without error.
简而言之,没有。更多细节的差异....在一天结束的时候,将会有相当多的工作来确保它不会出错。
Also, going cloud does not make you not worry about stuff, backups especially. It is just that this is no longer in your own hands.
此外,使用云并不会让您不担心任何事情,尤其是备份。只是这已经不再是你自己的了。
#1
3
I don't know about a translator either. However, did you look at one of the managed database services for SQL Server out there like SQL Azure or Amazon RDS.
我也不认识翻译。但是,您是否查看过SQL Server的托管数据库服务,比如SQL Azure或Amazon RDS。
SQL Server Azure (http://msdn.microsoft.com/en-us/library/windowsazure/ee336279.aspx) is not completely compatible to a full SQL Server installation but it gets close.
SQL Server Azure (http://msdn.microsoft.com/en-us/library/windowsazure/ee336279.aspx)与完整的SQL服务器安装并不完全兼容,但已经很接近了。
Amazon's Relational Database Service (https://aws.amazon.com/rds/) lets you select between MySQL, Oracle and SQL Server. It is running the full SQL Server under the covers but has a few restrictions too.
Amazon的关系数据库服务(https://aws.amazon.com/rds/)允许您在MySQL、Oracle和SQL Server之间进行选择。它在后台运行完整的SQL服务器,但也有一些限制。
Both services allow you to not have to worry about hosting the server itself. However, database maintenance like backups, index maintenance and some performance tuning is still up to you.
这两个服务都允许您不必担心托管服务器本身。但是,数据库维护(如备份、索引维护和一些性能调优)仍然取决于您。
#2
1
In short, no. For more detail on the differences.... At the end of the day, there would be a fair amount of work making sure it would work without error.
简而言之,没有。更多细节的差异....在一天结束的时候,将会有相当多的工作来确保它不会出错。
Also, going cloud does not make you not worry about stuff, backups especially. It is just that this is no longer in your own hands.
此外,使用云并不会让您不担心任何事情,尤其是备份。只是这已经不再是你自己的了。