Re: FrontBase and write data export/import
Re: FrontBase and write data export/import
- Subject: Re: FrontBase and write data export/import
- From: David Holt <email@hidden>
- Date: Sat, 23 Aug 2008 09:54:48 -0700
This support page talks about writing out data:
http://www.frontbase.com/cgi-bin/WebObjects/FrontBase.woa/2/wa/supportPage?currentPage=TechnicalNotes&itemId=1000022
It appears to write out the whole database, no choice of tables. WRITE
DATA is also endian dependent so you won't be able to move data freely
from PowerPC to Intel or vice versa if that's an issue for you.
If you use the WRITE ALL OUTPUT command, you can later pick and choose
out of the generated SQL script which tables you wish to replicate.
You can also create a subset of the records you want to import. This
involves editing the generated scripts though. This is often the
approach that I take.
David
On 23-Aug-08, at 7:59 AM, Florijan Stamenkovic wrote:
William,
I just looked into some FB documentation, and I can find no
references to "WRITE DATA". I also can not find it in a the SQL
reference I use. So, I think you might be on a false track here...
I suggest writing to the FrontBase list, since you are not getting
any answers here, that might provide better results.
Or, if you are doing WO, maybe you could shift the export / import
procedure to the WO level? Though I guess that would defeat the
purpose of "keeping things simple" :)
Best regards,
F
On Aug 22, 2008, at 14:16, William Hatch wrote:
Hi,
I found a few threads that mentioned using a write data, as opposed
to write all output.... sql92 command for FrontBase. My goal is to
get a data export of a subset of table and then imported into
another FrontBase server; I don't need the entire db. Does anybody
have any usage examples of this? sql92 help doesn't list this, and
the docs don't mention it. Worst case, I supposed I could hack the
write all output generated schema.sql script to just do the inserts
I'm interested in, but thought there might be a more efficient way.
Thanks.
Bill
_______________________________________________
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