This discussion is archived
0 Replies Latest reply: May 2, 2012 3:45 PM by 907700 RSS

DBSQL Upgrade from 5.2.36 to 5.3.15

907700 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points