SQLBASE 8.5 1

[marioreininger]

I have my databases on SQLBASE 7.6.1 running.

I want to change to SQLBASE 8.5

Do the 7.6.1 databases run on a SQLBASE 8.5 server by copying the *.dbs files?

 

[ManuelPallas]

hi... there are two ways to convert the a 7.6.x database to 8.5:
1) unload the 7.6.x database to a unload file and then create a empty 8.5 database. after that you can load the unload file without any problems in the 8.5 database and your convertion is completed ;-)

2)Copy the 7.6.x-dbs-file (and the logfiles) to the 8.5 database-directory and connect with SQLTalk to this database. it is possible for 8.5 to convert the 7.6.x-DBS-file to a 8.5 database if the database is not so big, because sometimes the SQLBase hangs during the convertion and it will take much more time if you do the convertion by this way. :-(

I use the first option to convert a database. f.e. a database with a size of 4 GB takes for the load 30 minutes! This is very fast. You can use the following script to do this:

set server *8.5-servername*;
create database *8.5-database*;
connect *8.5-database* *user* *passeord*;
set bulk on;
set logbackup off;
set recovery off;
lock database;
commit;
load sql *7.6.x-unload-file* on server;
set bulk off;
set recovery on;
set logbackup on;
unlock database;
commit;

the LOCK DATABASE-command is very importent for the load-performance!!! if you dont lock the database during the load it will take much more time!! I don´t know why, ask gupta ;-)