Hi Jeremy et al., As far as I can tell, the MSSQL adapter does not appear to fully support creating models from linked servers ( https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-2017). Unfortunately, I have a use case in which the only way I can access certain tables & views is through a linked server connection (as regulations prevent us from connecting to the destination server directly).
Models can be created normally via: Sequel::Model Sequel[:server_name][:database_name][:table_schema][:table_name] But the queries that Sequel uses to determine the model's schema attempt to use the information_schema and sys schemas from the source server, rather than the linked server. Some initial investigation on my part appears to point to the #schema_parse_table method of the MSSQL adapter. Are there other locations within the code that would also need to be updated to support linked servers? Are there any preferences for how support for linked servers should be added? (connection options, option names, model options, etc.) Thanks, - Kenaniah -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/658daf82-dc1c-4127-9ffd-ad024d4dc588%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
