Corrupted BC14 repair

chrmrn
chrmrn Member Posts: 12
in NAV Three Tier
Dear Experts,

I have corrupted BC14 database.
For example does not generate symbols. DB is also not synchronizing with -FORCE
I found few tables which are visible in NAV but not at SQL!
How to recreate them in SQL? Is there easy way?

Thanks!
Kris

Answers

  • SanderDk
    SanderDk Member Posts: 507
    To My knowledge it cannot be done, if table is lost in SQL, then data is lost.
    If data does not matter, can you export the object as text?
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • chrmrn
    chrmrn Member Posts: 12
    Data is not that important. It can be transferred via SQL sp to target. The problem is a) synchronization failed, b) no symbols - this is a real pain. I tried to export table in question to fob, delete table, reimport - none. Tried to recreate the table from SQL - none - synchronization is still failing on that table ...
    Do you have any scenario to check?
    Thanks a lot guys!

Categories