Re: Btrieve C apps to MS SQL

#1

Convert Btrieve to SQLServer? Many have tried, few have succeeded.

Btrieve developers code their app to work on single records at a time, and
they are able to optimize the system to run very efficiently and quite
fast.

SQLServer developers code their apps to work on sets of records, and to
maintain performance, SQLServer developers code very relationally (with
normalized data) and put as much code into the database as possible in the
form of stored procedures.

These are really two very different theories of application development.
Your best bet is to NOT simply port the application, but redesign the
database from scratch in a good normalized database structure, and design
the software to work with SQL queries in mind.

Best of luck!
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: September 16-18: See our web site for details!

Trey Smith wrote:

Quote:

I've got a TON of C language (not C++) applications that call the
Btrieve API. My customer wants to convert everything to MS SQL Server.
It seems my choices are rewriting all of the database code from
scratch to work with one of the SQL Server APIs (ADO?), or use
something like Mertech's Btrieve to SQL driver.
http://www.mertechdata.com/homepage/sqlbtr.asp

Has anyone used the Mertech product, and what were your results?

Any suggestions on how to accomplish this project are kindly
appreciated.

Trey Smith

#2

Trey,

The mertech drivers for pervasive are originating from drivers to Oracle,
SQL-Server and now My-SQL from a database developement tool called Dataflex
(Df) or Visual Dataflex (Vdf).
Dataflex is a database like Btrieve. Record orientated but can connect
through database drivers to almost all database backend's.

The drivers (Mertech) allow a Df or Vdf developer to connect to the above
databases without Code Changes. By that extending your market potential (I
want an Oracle backend !!) without mostly very expensive re-designing and or
re-coding your application. It has been proven successfull to the Df and Vdf
market.

Peter

"Trey Smith" <treysmit (AT) _NOSPLAM_comcast (DOT) net> wrote

Quote:

Bill,
Believe it or not, my Btrieve databases are normalized to third normal
form. Instead of SQL JOINs, I did them myself with BTRV GETs and loops
with arrays (for recordset equivalents). I did all of this WAY before
I knew of SQL or normalization in a formal sense.

I am really interested in Mertech's approach. It would save me a lot
of time. Does anyone have any knowledge of the efficacy and
reliability their "Btrieve API to MS SQL" drivers?

It appears my choices are:
1. Code for OLEDB myself.
2. Code for ADO myself.
3. Use Mertech and jsut drop in their 2 DLLs on top of 2 existing
Pervasive DLLs.

Thanks,
Trey

On 11 Jul 2003 17:04:59 GMT, Bill Bach <bbach (AT) cncdsl (DOT) com> wrote:

Convert Btrieve to SQLServer? Many have tried, few have succeeded.

Btrieve developers code their app to work on single records at a time,
and
they are able to optimize the system to run very efficiently and quite
fast.

SQLServer developers code their apps to work on sets of records, and to
maintain performance, SQLServer developers code very relationally (with
normalized data) and put as much code into the database as possible in
the
form of stored procedures.

These are really two very different theories of application development.
Your best bet is to NOT simply port the application, but redesign the
database from scratch in a good normalized database structure, and design
the software to work with SQL queries in mind.

Best of luck!
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: September 16-18: See our web site for details!

Trey Smith wrote:

I've got a TON of C language (not C++) applications that call the
Btrieve API. My customer wants to convert everything to MS SQL Server.
It seems my choices are rewriting all of the database code from
scratch to work with one of the SQL Server APIs (ADO?), or use
something like Mertech's Btrieve to SQL driver.
http://www.mertechdata.com/homepage/sqlbtr.asp

Has anyone used the Mertech product, and what were your results?

Any suggestions on how to accomplish this project are kindly
appreciated.

Trey Smith

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Btrieve C apps to MS SQL

comp.databases.btrieve comp.databases.btrieve

Re: Btrieve C apps to MS SQL - 07-11-2003 , 12:04 PM

Re: Btrieve C apps to MS SQL - 07-22-2003 , 08:48 AM