Unable to import objects & database size is >465 Gb

prateekarya2011
prateekarya2011 Member Posts: 40
edited 2014-01-22 in NAV/Navision Classic Client
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

Comments

  • geordie
    geordie Member Posts: 655
    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?
    * Daniele Rebussi * | * Rebu NAV Diary *
  • kriki
    kriki Member, Moderator Posts: 9,124
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • prateekarya2011
    prateekarya2011 Member Posts: 40
    Thanx Kirki & geordie..;-) :o
    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
    prateekarya2011 Member Posts: 40
    And seriously your replies were helpful.... =D> :)

Categories