configuration file: database.config file for SQL SERVER 2014

[santoshpatro]

I am using mongify (http://mongify.com/) to migrate data from SQL SERVER 2014 to MongoDB. I have the following database.config file:

database.config:

sql_connection do
  adapter   "sqlserver"
  host      "<DATABASE SERVERNAME>"
  username  "<USERNAME>"
  password  "<PASSWORD>"
  database  "<DATABASENAME>"
end

mongodb_connection do
  host      "localhost"
  database  "<DATABASENAME>"
end

Based on the instructions mentioned in the portal I then tried to test the following command:

mongify check database.config

I got the following error:

C:/Ruby23/lib/ruby/2.3.0/rubygems/core_ext/kernel_require.rb:55:in `require': Could not load 'active_record/connection_adapters/sqlserver_adapter_adapter'. Make sure that the adapter in config/database.yml is valid. If you use an adapter other than 'mysql', 'mysql2', 'postgresql' or 'sqlite3' add the necessary adapter gem to the Gemfile. (LoadError)
        from C:/Ruby23/lib/ruby/2.3.0/rubygems/core_ext/kernel_require.rb:55:in `require'
        from C:/temp/.gem/gems/activesupport-4.2.10/lib/active_support/dependencies.rb:274:in `block in require'
        from C:/temp/.gem/gems/activesupport-4.2.10/lib/active_support/dependencies.rb:240:in `load_dependency'
        from C:/temp/.gem/gems/activesupport-4.2.10/lib/active_support/dependencies.rb:274:in `require'
        from C:/temp/.gem/gems/activerecord-4.2.10/lib/active_record/connection_adapters/connection_specification.rb:175:in `spec'
        from C:/temp/.gem/gems/activerecord-4.2.10/lib/active_record/connection_handling.rb:50:in `establish_connection'
        from C:/temp/.gem/gems/mongify-1.3.2/lib/mongify/database/sql_connection.rb:40:in `setup_connection_adapter'
        from C:/temp/.gem/gems/mongify-1.3.2/lib/mongify/database/sql_connection.rb:56:in `has_connection?'
        from C:/temp/.gem/gems/mongify-1.3.2/lib/mongify/cli/command/worker.rb:99:in `check_sql_connection'
        from C:/temp/.gem/gems/mongify-1.3.2/lib/mongify/cli/command/worker.rb:68:in `execute'
        from C:/temp/.gem/gems/mongify-1.3.2/lib/mongify/cli/application.rb:28:in `execute!'
        from C:/temp/.gem/gems/mongify-1.3.2/bin/mongify:17:in `<top (required)>'
        from C:/temp/.gem/bin/mongify:23:in `load'
        from C:/v/.gem/bin/mongify:23:in `<main>'

Can anyone help me to fix this issue

[santoshpatro]

I have installed gem install activerecord-sqlserver-adapter and here goes the list of installed gems in my system.

LOCAL GEMS

activemodel (5.1.6, 4.2.10) activerecord (5.1.6, 4.2.10) activerecord-sqlserver-adapter (5.1.6) activesupport (5.1.6, 4.2.10) arel (8.0.0, 6.0.4) bigdecimal (1.2.8) bson (1.12.5) bson_ext (1.12.5) builder (3.2.3) bundler (1.15.4) chunky_png (1.3.8) compass (1.0.3) compass-core (1.0.3) compass-import-once (1.0.5) concurrent-ruby (1.0.5) did_you_mean (1.0.0) ffi (1.9.18 x86-mingw32) highline (1.7.8) i18n (0.9.5) io-console (0.4.5) json (1.8.3) minitest (5.8.3) mongify (1.3.2) mongo (1.12.5) multi_json (1.12.2) net-telnet (0.1.1) power_assert (0.2.6) psych (2.0.17) rake (10.4.2) rb-fsevent (0.10.2) rb-inotify (0.9.10) rdoc (4.2.1) sass (3.4.25) test-unit (3.1.5) thread_safe (0.3.6) tiny_tds (2.1.2 x86-mingw32) tzinfo (1.2.5)

But still I am getting the below error on checking the command: mongify check database.config

C:/temp/.gem/gems/activerecord-4.2.10/lib/active_record/connection_adapters/connection_specification.rb:177:in `rescue in spec': Specified 'sqlserver' for database adapter, but the gem is not loaded. Add `gem 'activerecord-sqlserver-adapter'` to your Gemfile (and ensure its version is at the minimum required by ActiveRecord). (Gem::LoadError)
        from C:/temp/.gem/gems/activerecord-4.2.10/lib/active_record/connection_adapters/connection_specification.rb:174:in `spec'
        from C:/temp/.gem/gems/activerecord-4.2.10/lib/active_record/connection_handling.rb:50:in `establish_connection'
        from C:/temp/.gem/gems/mongify-1.3.2/lib/mongify/database/sql_connection.rb:40:in `setup_connection_adapter'
        from C:/temp/.gem/gems/mongify-1.3.2/lib/mongify/database/sql_connection.rb:56:in `has_connection?'
        from C:/temp/.gem/gems/mongify-1.3.2/lib/mongify/cli/command/worker.rb:99:in `check_sql_connection'
        from C:/temp/.gem/gems/mongify-1.3.2/lib/mongify/cli/command/worker.rb:68:in `execute'
        from C:/temp/.gem/gems/mongify-1.3.2/lib/mongify/cli/application.rb:28:in `execute!'
        from C:/temp/.gem/gems/mongify-1.3.2/bin/mongify:17:in `<top (required)>'
        from C:/temp/Sites/.gem/bin/mongify:23:in `load'
        from C:/temp/.gem/bin/mongify:23:in `<main>'

[anlek]

Hello, I'm sorry to say but I am unable to help with SQL Server setups as I don't have access to a server to test. However, you can see other issues users have submitted regarding this, a good one to read is #96.

[santoshpatro]

Hi Andrew,

Thanks much for your response. Sure I will take a look into it. In the mean time if you can help us some article in your blog site will be a great help to everyone.

Many applications are looking forward to migrate from SQL SERVER 2014 to Mongodb.

It will much helpful for us.

Thanks, Santosh

On Wed, Aug 8, 2018 at 11:16 PM, Andrew Kalek notifications@github.com wrote:

Hello, I'm sorry to say but I am unable to help with SQL Server setups as I don't have access to a server to test. However, you can see other issues users have submitted regarding this, a good one to read is #96 https://github.com/anlek/mongify/issues/96.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/anlek/mongify/issues/170#issuecomment-411492757, or mute the thread https://github.com/notifications/unsubscribe-auth/ADKZlLjhQajL5a5l7NsR2oP_0QVEYFrAks5uOyPfgaJpZM4VwjIe .

[dewelloper]

if you have not put the timeout parameter to database.config file then it gives this error. I think this is worked before versions of the ruby 3.2 but afterwards they added new features and this oppurtunuty failed. There i read someone solved this issure by wrapping this gem file with a new gem project. I dont know ruby and even i dont want to attempt to write a wrapper project for this process. If i need writing a new project for a solution for this i can write that propject any platform. This is very stupid..