Re: [OT] Frontbase Export/Dump
Re: [OT] Frontbase Export/Dump
- Subject: Re: [OT] Frontbase Export/Dump
- From: Chuck Hill <email@hidden>
- Date: Mon, 12 May 2008 09:48:05 -0700
On May 11, 2008, at 11:18 PM, Guido Neitzer wrote:
As long as you stay on FrontBase it is very easy. The only thing to
do is to have the files to be imported in the same location because
FrontBase stores absolute references in the dump. So, if you dumped
to /Library/Databases/dumps/MyDump, you have to create that path on
the new machine, copy the dump there and import from there. Quite
annoying but it works.
Hands down, the worst engineering decision made by FrontBase. Not
that there is a lot of competition, but this one is really bad.
Chuck
For transferring data between a FrontBase and a PostgreSQL database
I used the ERXJDBCUtilities a couple of times.
Depending on what and how much and how you want to move it, DBUnit is
another choice. I use it to stored a canned bootstrap configuration
that is loaded when ever I recreate the database. It is easy to make
an ant tasks that rebuilds the DB and loads the bootstrap data.
Chuck
On 11.05.2008, at 22:45, William Hatch wrote:
I found it easy enough to get the export, but getting the data to
import was never achieved following the docs or any other round
reference. It'll be easier and quicker to use one of several free
tools to move the data.
Bill
On May 11, 2008, at 8:54 PM, David Holt wrote:
If you mean another FB database, you want to use:
5.5.5 Export Into Flat-Files
FrontBase can export an entire database, schema definitions and
contents, into flat files in ASCII format
from which a database can later be rebuilt.
Two purposes of the flat-file export/import functionality are:
1. Backup and Restore of a database in ASCII form.
2. Porting of a database between platforms of different "endian"
type (big-endian/little-endian).
The following SQL 92 statements will respectively export and
import a complete database:
WRITE ALL OUTPUT(DIR='<path-to-export-directory>', CONTENT=TRUE);
SCRIPT <path-to-export-directory>/schema.sql;
This approach is described fully in the section “Enhanced Flat-
File Import and Export Functions” on page
88.
On 11-May-08, at 4:45 PM, Joshua Paul wrote:
The Frontbase site is not available right now, so I figured I'd
turn here for help...
Does anyone know how to dump data out of one FB database for use
in another?
--
Josh Paul
email@hidden
twitter: joshpaul
linkedin: joshpaul
NOTICE: This e-mail message and all attachments transmitted with
it are intended solely for the use of the addressee and may
contain legally privileged and confidential information. If the
reader of this message is not the intended recipient, or an
employee or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any
dissemination, distribution, copying, or other use of this
message or its attachments is strictly prohibited. If you have
received this message in error, please notify the sender
immediately by replying to this message and please delete it from
your computer.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
http://www.event-s.net
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden