Solved

Packing Interbase without gback?

Posted on 1998-05-13
5
162 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

679 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