> Hi,

> I need to load data from sql to mongo. in sql i have 42 tables , so a
> document needs to be generated by those 42 tables, just i created a stored
> procedure which will deal all the tables and with the help of C# class
> structures i loaded those records as a batch of 5000, which is taking 7.5
> hours to load complete 2 million records.

> is there any better way to load the data to mongo?

> i tried in another way like
> 1. loaded base table
> 2. updated with the second table using Save method which take 3.5 hours to
> update 2 million documents.( i need to do all other 41  tables and this is
> time taking process)

> please help me in this regard.

> Thanks

> Are you running those stored procedures to create a non-relational model?

> Mongoimport can import json and csv files.

> On Monday, October 1, 2012 9:53:15 PM UTC+1, abdul kadar wrote:

>> Hi,

>> I need to load data from sql to mongo. in sql i have 42 tables , so a
>> document needs to be generated by those 42 tables, just i created a stored
>> procedure which will deal all the tables and with the help of C# class
>> structures i loaded those records as a batch of 5000, which is taking 7.5
>> hours to load complete 2 million records.

>> is there any better way to load the data to mongo?

>> i tried in another way like
>> 1. loaded base table
>> 2. updated with the second table using Save method which take 3.5 hours
>> to update 2 million documents.( i need to do all other 41  tables and this
>> is time taking process)

>> please help me in this regard.

>> Thanks

> yes, then i form the document structure from .net application and saving
> into mongo..

> if 1 table data refresh happen then can i update that table information
> alone in mongo?is it advisable?

> Thanks
> Abdul Kadar

> On Tuesday, October 2, 2012 9:19:00 AM UTC-4, Gianfranco wrote:

>> Are you running those stored procedures to create a non-relational model?

>> Mongoimport can import json and csv files.

>> On Monday, October 1, 2012 9:53:15 PM UTC+1, abdul kadar wrote:

>>> Hi,

>>> I need to load data from sql to mongo. in sql i have 42 tables , so a
>>> document needs to be generated by those 42 tables, just i created a stored
>>> procedure which will deal all the tables and with the help of C# class
>>> structures i loaded those records as a batch of 5000, which is taking 7.5
>>> hours to load complete 2 million records.

>>> is there any better way to load the data to mongo?

>>> i tried in another way like
>>> 1. loaded base table
>>> 2. updated with the second table using Save method which take 3.5 hours
>>> to update 2 million documents.( i need to do all other 41  tables and this
>>> is time taking process)

>>> please help me in this regard.

>>> Thanks