Solved

Packing Interbase without gback?

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Strange behavior when a form is closed 6 58
LAN or WAN ? 11 92
Delphi: making a BW image transparent 10 40
MS Access from Delphi 31 32
The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

803 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