activerecord-sqlserver-adapter

activerecord-sqlserver-adapter copied to clipboard

Not all data sources are found

5

## Issue When using a database with multiple schemas, not all tables are found for method ```ruby ActiveRecord::Base.connection.data_sources ``` It seems to stem from this [line](https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/blob/6-0-stable/lib/active_record/connection_adapters/sqlserver/schema_statements.rb#L322). When `ActiveRecord::Base.connection.data_source_sql` is called,...

DCrow

Still problems with ActiveRecord::ConnectionNotEstablished (TinyTds::Error: failed to execute statement)

4

## Issue Hi, here is a description of my issue: ``` 2.7.0 :001 > Pratica.count SQL (17.4ms) USE [WinLEG] (18.0ms) SELECT COUNT(*) FROM [Pratiche] => 10854 ``` ... Waiting 30seconds...

marino-mrc

## Issue When invoking `structure_dump` on a database which has replication enabled, a number of replication tables and views are created which should not be managed by external tools. A...

jonahgeorge

## Issue Given an example schema: ```sql create table posts ( ID int identity, Body varchar(max) not null, ) go create view popular_posts as select * from posts ``` `structure_dump`...

jonahgeorge

Currently, [`SQLServerDatabaseTasks#structure_dump`](https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/blob/main/lib/active_record/tasks/sqlserver_database_tasks.rb#L56-L80) supports exporting tables and views; however, the underlying tool [`defncopy`](https://github.com/FreeTDS/freetds/blob/master/src/apps/defncopy.c) supports stored procedures as well. It would be particularly helpful to export stored procedures from an existing database,...

jonahgeorge

Nil variable @version_year is causing error when Rails try to load schema on the test database

9

## Issue Cannot setup test db properly because `db:schema:load` is raising `NoMethodError: undefined method `

theo-bittencourt

Rails tests can't truncate tables when run in parallel

3

## Issue Using Minitest and fixtures I will get an error `ActiveRecord::StatementInvalid: TinyTds::Error: Cannot truncate table 'active_storage_blobs' because it is being referenced by a FOREIGN KEY constraint.` when I try...

erlingur

Support for structure.sql seems to be broken

9

activerecord-sqlserver-adapter (6.1.0.0) tiny_tds (2.1.5) Compile-time settings (established with the "configure" script) Version: freetds v1.2.18 freetds.conf directory: /etc MS db-lib source compatibility: yes Sybase binary compatibility: no Thread safety: yes iconv...

gucki

dateformat to ISO 8601

9

Change date format for SQL server and Azure that date format will always be ISO 8601 format.

YvesR

Add documentation for when and why to turn on or off use_output_inserted

2

I can't see the downside to using OUTPUT INSERTED. The option to turn this off exists, but there is no explanation I can find about when and why one would...

gisborne