Question 1

How to call a SQL Server stored procedure from Rails?

Accepted Answer

Use the execute_procedure method on your model, e.g., Account.execute_procedure(:update_totals, 'admin'). The adapter automatically quotes arguments and supports named parameters, as shown in the README.

Question 2

ActiveRecord SQL Server adapter vs PostgreSQL adapter for upsert operations?

Accepted Answer

The SQL Server adapter uses a MERGE statement for upsert_all, which joins data and removes duplicates, unlike PostgreSQL's ON CONFLICT clause. This can lead to different performance characteristics and syntax, as explained in the insert_all/upsert_all section.

Question 3

What are the common issues with SQL Server and Rails migrations?

Accepted Answer

Common pitfalls include handling schemas with prefixes like 'dbo.', configuring identity inserts for tables with triggers, and ensuring correct data type mappings for columns like datetime2, which require TDS version 7.3.

Question 4

How to handle datetime columns with precision in SQL Server Rails adapter?

Accepted Answer

By default, datetime columns use precision 6 and map to datetime2; to use a plain datetime column, specify nil precision in migrations. This is detailed in the Native Data Type Support section of the README.

Question 5

Can I use computed columns in Rails with SQL Server?

Accepted Answer

Yes, create virtual or persisted computed columns in migrations using t.virtual with an 'as' clause, e.g., t.virtual :name_length, as: 'LEN(name)'. The adapter supports both stored and non-stored options.

Question 6

What versions of Rails does the SQL Server adapter support?

Accepted Answer

It follows Rails' maintenance policy, with active support for recent versions like 8.0.x and 8.1.x, and ended support for older ones. Check the version table in the README for specific mappings and support status.

activerecord-sqlserver-adapter

What is activerecord-sqlserver-adapter?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions