Link to home
Start Free TrialLog in
Avatar of roy_sanu
roy_sanuFlag for India

asked on

conversion of SQL server data to mongodb

How to convert 250 tables data with 90 GB of database data to mongodb. please let me know the approach

Thanks
Avatar of roy_sanu
roy_sanu
Flag of India image

ASKER

do I have to map the database table to mongodb document structure or any tool can do that . Its urgent
Avatar of Dave Baldwin
Converting the SQL data isn't even the important part.  You have to convert / re-create all of your queries because MongoDB isn't SQL, doesn't run SQL queries.  More info: http://docs.mongodb.org/manual/tutorial/query-documents/
So I think I need to create collection in mongodb which is same as table structure and create  documents and relationship between the documents . pls clarify if that is correct
ASKER CERTIFIED SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
the philosophy behind using noSQL databases such as MongoDB is that the data needs to be stored in a fashion that makes it easy for consuming applications to read and write therefore reducing latency.

Simply trying to map your RDBMS data to nosql won't work. You need to look at the use cases for your applications.