Solved

Packing Interbase without gback?

Posted on 1998-05-13
5
156 Views
Last Modified: 2010-04-06
Is there any way to pack an Interbase database without using the GBACK.EXE utility?  We have a spec is dictating a pack, and doing it through GBACK has been rejected.   If anybody knows anything, I would greatly appreciate any help.. even if it is crazy convoluted code, I can figure it out.

-greendot
0
Comment
Question by:greendot2
  • 3
  • 2
5 Comments
 

Author Comment

by:greendot2
ID: 1345311
Adjusted points to 300
0
 
LVL 10

Accepted Solution

by:
Jacco earned 300 total points
ID: 1345312
First of all the answer is no.

No other utility can do a good pack other then GBAK.EXE.
GBAK.EXE comes with IntrBase and is different for every version. It always supports the newest "on disk structure".

I have the same problems you have an have solved it partially.

I wanted to show the user the progress of the backup/restore action. But not in a DOS box. I looked how InterBase has done it in there Server Manager. They don't use a normal DOS box they have a special window which calls a CreateProcess with the StdIn and StOut diverted to there Memo control. I haven't figured out yet how to do that but it must be possible. That way the user isn't bothered with the DOS box. The login parameters can be specified in the command line of GBAK.EXE.

Another possiblilty is to extract all the meta-information of the database to a file. Create a new database from this file. And BatchMove (or manually move) the data from the old database to the new one. This is not the same at backup/restoring though because the indexes will not be balanced then. This means that the database restored (packed) in this was will be slower on the indexes.

Hope I have helped you a bit.

Regards Jacco
0
 

Author Comment

by:greendot2
ID: 1345313
Ugh, I was afraid of this..


0
 
LVL 10

Expert Comment

by:Jacco
ID: 1345314
Me too... Maybe we can ask IntrBase Corp for a solution...
0
 
LVL 10

Expert Comment

by:Jacco
ID: 1345315
Me too... Maybe we can ask IntrBase Corp for a solution...
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now