Re: [OT] Frontbase Export/Dump
Re: [OT] Frontbase Export/Dump
- Subject: Re: [OT] Frontbase Export/Dump
- From: Guido Neitzer <email@hidden>
- Date: Mon, 12 May 2008 00:18:09 -0600
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.
For transferring data between a FrontBase and a PostgreSQL database I
used the ERXJDBCUtilities a couple of times.
cug
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