Unable to import objects & database size is >465 Gb

prateekarya2011

Hii all,
My client had certain requirements and so i started development but it failed when i added new fields in sales line and other tables.
To continue with development i imported all the modified objects to nav 4.0 base Db.
After development when i am trying to import the objects into client's DB, system again goes into an unending loop.
Plz give ur suggestions.

*Remember size of DB is GREATER THAN 465 GB.
](*,) :-k

geordie

I think due to the database size modifying tables structure (when you import the customized version with added fiels) can take long time: did you give a try importing just a few objects each time?

kriki

And do you have enough space on your disk for the transaction log? Also let your transaction log be big enough to take some heavy writing in 1 transaction without needing to autogrow. And then let it grow with big enough increments. With your DB, I would set it to 1 GB.

prateekarya2011

Thanx Kirki & geordie..;-)
I found the other way out.. The db had more than 20 companies and i wasn't able to upload my objects & test.
So i took the backup of one single company on which testing was to be done.
And after testing 'll import the objects to test DB one by one.

prateekarya2011

And seriously your replies were helpful.... =D>