[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Packing Interbase without gback?

Posted on 1998-05-13
5
Medium Priority
?
166 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 

Author Comment

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

Accepted Solution

by:
Jacco earned 900 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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

656 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