0 Replies Latest reply: May 2, 2012 5:45 PM by 907700 RSS

    DBSQL Upgrade from 5.2.36 to 5.3.15

    907700
      Hi,

      I am currently trying to upgrade my existing DBSQL databases from Berkeley DB version 5.2.36 to version 5.3.15.

      I ran the db_upgrade utility on the existing database file created by BDB version 5.2.36. The upgrde goes through successfully. But the query "select rowid from table1" gives a huge negative integer as row numbers for the records in the table.

      Looking at the sqlite3.c file I noticed that encodeI64() funtion has been removed in the version 5.3.15. Is this causing the issue?

      Please provide a feasiable solution for upgrading the datbases from version 5.2.36 to 5.3.15.

      Note: The ".dump" dbsql command is not applicable in our case as we wish to maintain the rowid of all the records from the database from version 5.2.36.

      Thanks
      Sandeep