Re: How to import/export D3-NT data to MS SQL?

Hi
It sounds like you need Ross Ferris bit technology from Visage . You should
also look at Grigory's suggestion From Briz he has some fantastic work
interfacing using a variety of languages, the method I find most interesting
is all Pick Basic calling his C++ routines, easy for a Pickie to understand
and blisteringly fast.
Peter McMurray
"VNVJeep" <mvanzwieten@xxxxxxxxx> wrote in message
news:1155067256.255293.163050@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi All,

Due to some heavy, heavy reporting needs, neither the ODBC server or
PDP for .Net solution for D3 are not performing as good as we had hoped
for... Some of our reports chug for 4-6hrs before giving us any
results, while others don't even make it that far before just
completely bombing out due to the number or complexity of queries we
have in the report to make it all happen. We are using Crystal Reports
XI on Windows XP. D3 7.4.4 is running on a Win2k3 SP1 Dual Xeon 3.2ghz,
2gig RAM, Raid 1 (OS), Raid 5 (D3 data) with 10k RPM drives.

In our desperation, we are hoping to bounce this question off of you
all with the hopes of there being a solution out there that will help
us resolve this issue!

Are there any methods, or 3rd party solutions out there that are able
to transfer data from D3 into MS SQL server continously, or perhaps in
batches, based on changed data? Is it possible to export changed data
automatically over to a SQL database? If not, is it possible to use a
tool to import data into SQL from D3? Are there any tools out there
that monitor D3 database activity, and are able to export these changes
out for SQL to pick up and import?

Any creative suggestions are welcome! Thank you in advance for writing!

Take care,
Mike



.

Relevant Pages

  • How to import/export D3-NT data to MS SQL?
    ... Due to some heavy, heavy reporting needs, neither the ODBC server or ... We are using Crystal Reports ... Is it possible to export changed data ... automatically over to a SQL database? ...
    (comp.databases.pick)
  • Re: Flat file logging and moving log files to SQL satabase
    ... logging to SQL directly) when transfering to SQL Server, ... ISA Server Product Team ... question is what is the best way of running reports on the SQL database. ...
    (microsoft.public.isa)
  • Re: ISA Log to SQL Database Question
    ... We use the SQL DB because we have written custom ... With the default reports their is not way to say that User Jones ... >> With MSDE the logging interface in ISA lets you set the maximum size limits. ... >>> WebProxyLog table to a SQL Database. ...
    (microsoft.public.isa.configuration)
  • Re: Linked SQL Table Problem
    ... > said that when linking it will ask for me to choose the primary keys, ... I'm not needing to add info to the SQL table, ... > One other thing is that I can not make any changes to the SQL database ... > I can custom create my own reports from the info gathered in the SQL ...
    (microsoft.public.access.tablesdbdesign)
  • Linked SQL Table Problem
    ... I am trying to link to a SQL table through ODBC. ... said that when linking it will ask for me to choose the primary keys, ... One other thing is that I can not make any changes to the SQL database ... I can custom create my own reports from the info gathered in the SQL ...
    (microsoft.public.access.tablesdbdesign)