activerecord-sqlserver-adapter

activerecord-sqlserver-adapter copied to clipboard

Add some more niceties to the database tasks

1

bf4

Dump one DB with multiple schemas

1

## Issue I'm trying to dump all schemas from a legacy db (not on my machine), it's just one db. But the only schema i get is dbo and it's...

TulioMagnus

ActiveRecord::StatementInvalid: TinyTds::Error: Incorrect syntax near '0'

1

## Issue irb(main):001:0> UserT.count SQL (4.9ms) USE [GenDB] (5.5ms) SELECT COUNT(*) FROM [UserT] => 2 irb(main):003:0> UserT.first UserT Load (9.6ms) EXEC sp_executesql N'SELECT [UserT].* FROM [UserT] OFFSET 0 ROWS FETCH...

aet08

insert_all/upsert_implementation using MERGE

1

This PR resolves the issue https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/issues/859. Since it adds support to `insert_on_duplicate_skip` it also resolves https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/issues/847. The PR is in early stages. I'm exploring adding `supports_insert_on_duplicate_skip` first (insert_all). Upsert_all is...

mgrunberg

ActiveRecord::ConnectionAdapters::SQLServerAdapter does not support skipping duplicates

5

## Issue `bundle exec rails db:seed` throws `ActiveRecord::ConnectionAdapters::SQLServerAdapter does not support skipping duplicates`. ## Expected behavior A single SQL INSERT should be generated and executed ## Actual behavior When using...

Quintasan

Check if insert_all/upsert_all can be implemented using MERGE

1

## Issue Rails 6 introduced [`upsert_all`](https://apidock.com/rails/v6.0.0/ActiveRecord/Persistence/ClassMethods/upsert_all) and the SQL Server adapter does not implement it yet. There's no such thing as MySQL's `ON DUPLICATE KEY UPDATE` in SQL Server, but...

wpolicarpo

[WIP] coerce types for config parameters; add missing config parameters recognized by TinyTDS -- Issue #740

3

coerce types for config parameters; add missing config parameters recognized by TinyTDS -- Issue #740 see also: https://github.com/rails-sqlserver/tiny_tds/issues/461

PaulCharlton

Support for multiple schema types when dumping schema; potential fix for #317

1

This is what I got. PR for specs and questions. This PR allows `rake db:schema:dump` to dump the database schema for all microsoft table schemas. It does this through exposing...

alexggordon

Jdbc mode

30

- Drop strict gem dependency on tiny_tds. - Add gem dependency for tests on new (un-published) gem sqljdbc4 which bundles the MS jdbc driver. - Implement a thin ruby jdbc...

iaddict

Rails decimals data types detected as nvarchar

1

## Issue The adapter is translating Rails models decimal attributes as nvarchars (in SQL Server 2019 they are defined as numerics with different precisions). If I change the attributes to...

mariolopes