Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can connect to db but db:structure:dump is not right #470

Closed
TulioMagnus opened this issue May 20, 2020 · 1 comment
Closed

Can connect to db but db:structure:dump is not right #470

TulioMagnus opened this issue May 20, 2020 · 1 comment

Comments

@TulioMagnus
Copy link

Environment

Linux Mint 19

TinyTDS Version and Information

    gem 'tiny_tds', '~> 2.1', '>= 2.1.2'                      

FreeTDS Version

Version: freetds v1.00.82
             freetds.conf directory: /etc/freetds
     MS db-lib source compatibility: no
        Sybase binary compatibility: yes
                      Thread safety: yes
                      iconv library: yes
                        TDS version: 4.2
                              iODBC: no
                           unixodbc: yes
              SSPI "trusted" logins: no
                           Kerberos: yes
                            OpenSSL: no
                             GnuTLS: yes
                               MARS: no

Rails -v: 5.2.4.2

Description

Hi, i'm trying to dump the development DB schemas that are on a legacy DB to load on a docker localhost test DB, using rails db:structure:dump

My legacy DB has multiple schemas and tables, like Security.User, Ticket.Park.

I can connect to the database alright, setting the User model to self.table_name = 'Security.User'

But when i dump the db using rails db:structure:dump it only generates the structure with dbo schema with sysdiagrams table.

I'm usign in config/application.rb: config.active_record.schema_format = :sql

is there anything i can do to dump this thing up?

thanks!

@wpolicarpo
Copy link
Member

This is repository and issue tracker are for tiny_tds, not the Rails adapter. Can you please open an issue here https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/issues?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants