Solved

Packing Interbase without gback?

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 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

22 Experts available now in Live!

Get 1:1 Help Now