 |
|
| Computers Forum Index » Computer - Databases - Btrieve » Need to Query a Pervasive 9.X DB... |
|
Page 1 of 1 |
|
| Author |
Message |
| SINNER... |
 Posted: Wed Oct 21, 2009 10:03 pm |
|
|
|
Guest
|
I need to query a pervasive 9.X DB and have the output to a txt or CSV
file. I tried using the internal pvddl tool but it seems to just
create/update ddf files in the database folder. (this is a transactional
not relational DB)
Optimally Id like to output in a specific format rather than just TXT or
CSV to meet a clients needs but If I could just get the data out for now I
can work that out. Any help appreciated.
--
David |
|
|
| Back to top |
|
|
|
| mehoss... |
| Posted: Thu Oct 22, 2009 12:39 pm |
|
|
|
Guest
|
If the trial versions are still available, download it It should
install an ActiveX interface. Then use the ActiveX interface in any
Microsoft VBScript macro capable product or visual studio or any other
ActiveX capable programing language to get the data
Worked for me several years ago.
On Oct 21, 2:03 pm, SINNER <arcade.mas... at (no spam) gmail.com> wrote:
Quote: I need to query a pervasive 9.X DB and have the output to a txt or CSV
file. I tried using the internal pvddl tool but it seems to just
create/update ddf files in the database folder. (this is a transactional
not relational DB)
Optimally Id like to output in a specific format rather than just TXT or
CSV to meet a clients needs but If I could just get the data out for now I
can work that out. Any help appreciated.
--
David |
|
|
| Back to top |
|
|
|
| mehoss... |
| Posted: Thu Oct 22, 2009 1:00 pm |
|
|
|
Guest
|
On Oct 21, 2:03 pm, SINNER <arcade.mas... at (no spam) gmail.com> wrote:
Quote: I need to query a pervasive 9.X DB and have the output to a txt or CSV
file. I tried using the internal pvddl tool but it seems to just
create/update ddf files in the database folder. (this is a transactional
not relational DB)
Optimally Id like to output in a specific format rather than just TXT or
CSV to meet a clients needs but If I could just get the data out for now I
can work that out. Any help appreciated.
--
David
If the trial versions are still available, download it It should
install crude tools to access the database via sql also It should
install an ActiveX interface. If you want to get fancy with the data,
Then use the ActiveX interface in any
Microsoft VBScript macro capable product or visual studio or any
other
ActiveX capable programing language to get the data
Worked for me several years ago |
|
|
| Back to top |
|
|
|
| BtrieveBill... |
| Posted: Sat Oct 24, 2009 10:10 pm |
|
|
|
Guest
|
If you are doing this manually, then you can use the included Pervasive
Control Center. Just right-click on the table in the PCC and select Export.
If you need this to be command-line driven, or include additional export
options, then you may want to look at an external tool. Our own SQLExec
(www.goldstarsoftware.com/sqlexec.asp) is a good start, and it allows
you to run extracts from the command line (like PVDDL, but with real
output) in a wide variety of export formats.
Of course, ANY ODBC-compliant export tool will also work for you, so if
you have an ETL program, like Informatica, Pervasive Data Integrator, or
the like, they will work quite well, too.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach at (no spam) goldstarsoftware.com
http://www.goldstarsoftware.com
*** Pervasive Training - October 2009 in Chicago ***
SINNER wrote:
Quote: I need to query a pervasive 9.X DB and have the output to a txt or CSV
file. I tried using the internal pvddl tool but it seems to just
create/update ddf files in the database folder. (this is a transactional
not relational DB)
Optimally Id like to output in a specific format rather than just TXT or
CSV to meet a clients needs but If I could just get the data out for now I
can work that out. Any help appreciated.
|
|
|
| Back to top |
|
|
|
| SINNER... |
| Posted: Fri Nov 06, 2009 2:56 am |
|
|
|
Guest
|
* BtrieveBill wrote in comp.databases.btrieve:
Quote: If you are doing this manually, then you can use the included
Pervasive Control Center. Just right-click on the table in the PCC
and select Export.
If you need this to be command-line driven, or include additional
export options, then you may want to look at an external tool. Our
own SQLExec (www.goldstarsoftware.com/sqlexec.asp) is a good start,
Your software was the first thing I found. The issue for me is that I need
to provide a solution to a client that is already going to come at a cost.
The application is client server based and installed at a number of sites
so licensing is going to be an issue.
Quote: and it allows you to run extracts from the command line (like PVDDL,
but with real output) in a wide variety of export formats.
Of course, ANY ODBC-compliant export tool will also work for you, so
if you have an ETL program, like Informatica, Pervasive Data
Integrator, or the like, they will work quite well, too.
Thanks Bill, I went with a freeware option that I found that allowed me to
complete the task. I appreciate the answer.
--
David |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Thu Dec 10, 2009 1:50 pm
|
|