search

anlek / mongify

Mongify allows you to map your data from a sql database and into a mongodb document database.
http://github.com/anlek/mongify
MIT License
317 stars 82 forks source link

Can mongo db server be only in localhost? #123

Closed devwwg closed 7 years ago

devwwg commented 7 years ago

I'd need to make a connection to a mongodb on a remote server, but i misunderstand if mongify can only connect on localhost. In your documentation i didn't find any information about that. I just found examples with "host" and "database" properties.

Thanks, Simone

anlek commented 7 years ago

Hey Simone, It's not that Mongify can't connect to a remote server, inder HOST, you would give the IP/URL of your server in the world. However, keep in mind that moving data via the internet has lag/delays. Meaning that if you have a million record you want to convert, locally it could take 10 minutes, remotely it might take 10 hours (as mongify has to query to database to ensure the relationships are kept).

I highly recommend doing the conversion locally (as you're likely to run it a bunch of times before you can fine tune everything) and once your data is in your local mongodb instance, use mongodump to dump the database and use mongorestore on the remote server to import the data.

Good luck! Andrew