Re: Import BTR files?
- From: "Dan Williams" <danATwillcraft.com>
- Date: Wed, 11 May 2005 11:55:30 -0600
Hi Paul,
What we want to do is on a scheduled nightly basis:
-import the customer master, and the parts master tables from the third
party database, to the custom written VFP database.
The main Business Application Software that is using Pervasive for Linux,
has all of the customer data, and parts inventory data. The Custom VFP app
for respect to the vendor of the Business Application Software will not tie
the two together. So the next best thing for us is to get that data nightly
(saves manually keeping up both databases)
Dan
"Paul Pedersen" <no-reply@xxxxxxxx> wrote in message
news:uScBFskVFHA.616@xxxxxxxxxxxxxxxxxxxxxxx
> Yes, it can be done. I access Btrieve data via ODBC. It's also possible to
> use a third party tool such as AutoBTR.
>
> Btrieve data is different in that the data structure is defined by a DDF
> file, which is external to the data file.
>
> Pervasive sells a "Workgroup engine" which allows access by both the new
> ODBC driver and legacy apps. It's pretty cheap, and comes with a license
> for five workstations in the local group. Access via ODBC is tolerable if
> you're simply reading a table, but doing even simple joins is
> excruciatingly slow. There are two methods of accessing the data, SQL and
> Transactional. AutoBTR uses transactional, which I think will be much
> faster (I don't have much experience with it), but it does not bring back
> data in the familiar cursor format.
>
> Pervasive also sells a server engine, much more expensive, but still way
> cheaper than MSSQL.
>
>
>
> "Dan Williams" <danATwillcraft.com> wrote in message
> news:11828t0k021vj29@xxxxxxxxxxxxxxxxxxxxx
>>I have in the past imported files from an AS400, and files from MS SQL, or
>>access etc.
>> Now I have a need to import the customer master table from a pervasive
>> database.
>> Having no experience with importing these types of files Iwanted to ask
>> first.
>> Can it be done, what do I need to know etc?
>> Thanks you
>> (the files end in .btr)
>>
>
>
.
- Follow-Ups:
- Re: Import BTR files?
- From: swdev2
- Re: Import BTR files?
- From: Paul Pedersen
- Re: Import BTR files?
- References:
- Import BTR files?
- From: Dan Williams
- Re: Import BTR files?
- From: Paul Pedersen
- Import BTR files?
- Prev by Date: Duplicate program??
- Next by Date: Re: Select Alias vs Data Session
- Previous by thread: Re: Import BTR files?
- Next by thread: Re: Import BTR files?
- Index(es):
Relevant Pages
|
|
