Rails和MSSQL2008-我们会遇到障碍吗？-Rails&MSSQL2008-WillWeHitBarriers?

The company I am working for is looking to switch platforms from ColdFusion 8 / Windows to Ruby on Rails / Linux. Our database solution will remain as MSSQL 2008 on Windows. I will likely follow up with a series of questions relating to this migration separately, but for now I have a MSSQL & Rails specific question.

我正在努力的公司正在寻求将平台从ColdFusion 8 / Windows切换到Ruby on Rails / Linux。我们的数据库解决方案将在Windows上保留为MSSQL 2008。我可能会分别跟进一系列有关此迁移的问题,但现在我有一个MSSQL和Rails特定的问题。

Back in 2006 when I was working with Ruby on Rails for the first time, support for MSSQL installations was pretty iffy. Things worked for the most part, but ActiveRecord couldn't cope with certain functions lacking from T-SQL. Primarily, I recall auto-paging not working due to a lack of an OFFSET keyword like the one found in MySQL.

早在2006年我第一次使用Ruby on Rails时,对MSSQL安装的支持非常不确定。事情大部分都有效,但ActiveRecord无法应对T-SQL缺少的某些功能。首先,我记得由于缺少像MySQL中那样的OFFSET关键字,自动分页无法正常工作。

I am curious if our primary DB server running MSSQL 2008 will be able take advantage of most of ActiveRecord's functionality. If there are particular features that are not available, I'd be curious as to what they are.

我很好奇我们运行MSSQL 2008的主数据库服务器是否能够利用ActiveRecord的大部分功能。如果有特定的功能不可用,我会很好奇它们是什么。

1 个解决方案