INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SQLBASE 8.5

SQLBASE 8.5

(OP)
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?

RE: SQLBASE 8.5

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close