Mongify allows you to map your data from a sql database and into a mongodb document database.
I'm kinda new to programming and find myself getting into some heavy stuff very quickly
Hey @anishratnam, Sorry about the late delay, I didn’t get notified. Are you still facing an issue? Try email me (andrew.kalek@anlek.com) with any questions.
Any hints on what my database.config should look like?
Also I am having trouble using the sync command
Can you please help me out with the proper usage ?
Can we migrate oracle to mongodb using mongify...could you please tell the exact oracle adapter...I have tried activerecord-oracle_enhanced-adapter (1.7.2) but it not helps anymore...I can able to do mysql to mongo db using mongify
*how I could possibly take my resulting document
just wanted to know if its possible to merge this into a single array after mongo import
I am embedding one table into another as an array, but the name of the table is no needed
Hi, I was wondering if anybody has successfully connected to an Oracle db with mongify? I'm trying to do a mongify check with my db.config file and it results in an error:
C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/activerecord-oracle_enhanced-adapter-1.7.4/lib/active_record/connection_adapters/oracle_enhanced/oci_connection.rb:7:in `rescue in <top (required)>': Could not load 'active_record/connection_adapters/oracle_enhanced_adapter'. Make sure that the adapter in config/database.yml is valid. If you use an adapter other than 'mysql2', 'postgresql' or 'sqlite3' add the necessary adapter gem to the Gemfile. (LoadError)
C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/activerecord-oracle_enhanced-adapter-1.7.4/lib/active_record/connection_adapters/oracle_enhanced/oci_connection.rb:7:in `rescue in <top (required)>': Could not load 'active_record/connection_adapters/oracle_enhanced_adapter'. Make sure that the adapter in config/database.yml is valid. If you use an adapter other than 'mysql2', 'postgresql' or 'sqlite3' add the necessary adapter gem to the Gemfile. (LoadError)
@haperlot It's hard to say what's going on without seeing your translation file.
i need help
i have installed mongify
hw do i get it working ..
wen i execute mongify check database.config
i get this
C:\Users\optimus93>mongify check database.config
C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/connection_specification.rb:177:in
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_handling.rb:50:in
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/database/sql_connection.rb:56:in
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/cli/command/worker.rb:68:in
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/bin/mongify:15:in
from C:/Ruby23-x64/bin/mongify:22:in `<main>'
C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/connection_specification.rb:177:in
rescue in spec': Specified 'mysql' for database adapter, but the gem is not loaded. Addgem 'mysql'to your Gemfile (and ensure its version is at the minimum required by ActiveRecord). (Gem::LoadError)
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/connection_specification.rb:174:inspec'from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_handling.rb:50:in
establish_connection'
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/database/sql_connection.rb:40:insetup_connection_adapter'from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/database/sql_connection.rb:56:in
has_connection?'
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/cli/command/worker.rb:99:incheck_sql_connection'from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/cli/command/worker.rb:68:in
execute'
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/cli/application.rb:28:inexecute!'from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/bin/mongify:15:in
<top (required)>'
from C:/Ruby23-x64/bin/mongify:22:inload'from C:/Ruby23-x64/bin/mongify:22:in `<main>'
i need a little bit of help
i trying to export data from sql to mongo
but i don't have any idea how configure it
i did some configurations but i'm not sure what i am doing
set @rownum := 0;
select round(avg(t1.lat_n), 4) as median_val
from (
select @rownum := @rownum + 1 as row_number, s.lat_n
from station s, (select @rownum := 0) r
order by s.lat_n
) as t1,
(
select count(*) as total_rows
from station
) as t2
where t1.row_number in (floor((total_rows + 1) / 2), floor((total_rows + 2) / 2));
select round(avg(t1.lat_n), 4) as median_val
from (
select @rownum := @rownum + 1 as row_number, s.lat_n
from station s, (select @rownum := 0) r
order by s.lat_n
) as t1,
(
select count(*) as total_rows
from station
) as t2
where t1.row_number in (floor((total_rows + 1) / 2), floor((total_rows + 2) / 2));
most especially the part that says (select @rownum := 0) r