Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #10478

Re: Advantage Database server

From "Marc Verkade" <marc@marc.marc>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Advantage Database server
Date 2017-04-19 18:00 +0200
Organization A noiseless patient Spider
Message-ID <od81cn$ke1$1@dont-email.me> (permalink)
References <286dc3c8-efd7-43f5-9668-8981466836d8@googlegroups.com> <a519a992-d11a-46f3-a1e1-51a872ed2bf2@googlegroups.com> <fiv2fc9jk415f326n2j12j9156kdgqvh5f@4ax.com>

Show all headers | View raw


Hey all,

I have done the transition from DBF to SQL Server in 2015 by creating a 
MC_SQLDbf class with VO2ADO which acted exactly like a DBFServer.
Next to that I created a mechanism to transform a repository containing a 
DBF Bake-it (our main VO application) to a new repository with a SQL Bake-it 
by using Reposcript (very nice piece of software!) and some replacement 
mechanism.
Also I created a DBF to SQL application which synchronized DBF tables to SQL 
at certain intervals so Bake-it SQL and Bake-it DBF could be used 
simultaneously more or less.
In that way our developers could still work on the Bake-it DBF version and 
when we want, generate a SQL Bake-it on the fly.

The project took me about 3 months work over a period of 9 months but 
finally everything went well and after we converted some 'sluggish' routines 
to stored procedures on the server, it was lightning fast too!
I did take a look at the SQL classes of Geoff Schaller but these were to 
complicated for us to use and I decided to write my own SQL wrapper. Also 
had some help from Robert which is a great guy creating great software!
To keep thing fast, I created a mechanism to only load data when needed and 
made sure I eliminated all full-table scans by using the SQL profiler.
At the end I only had to change a few windows, the way our selection windows 
were working (which loaded all records when starting) and routines to speed 
up things with code like:

If Universe:IsSQL
// Do this by using a stored procedure
Else
// Do that the DBF or DBFSQL way
End

The hard part was to change our Crystal Reports routines and convert the 
 >800 reports we had created through the years but even this was not that 
hard when I learned our guys how to do that and made a nice manual.

The very nice part was that development could still take place in a DBF 
environment and a Bake-it SQL could be generated on-the-fly with the Bake-it 
SQL Converter application (screenshot at 
http://www.extravestiging.nl/download/BakeItSQLConverter.jpg ) which created 
a completely fresh Bake-it SQL repository based on the Bake-it DBF 
repository, compiled the libraries and created a fresh Bake-itSQL.Exe

At the end, this process and Bake-it SQL were working very well, was stable, 
lightning fast when using stored procedures at certain places and was ready 
for testing and deployment.
Here the project of the Bake-It SQL Converter... perhaps somebody finds it 
useful... http://www.extravestiging.nl/download/BakeItSQLConverter.zip

But then, the management of Marti, my old company, for which I did this 
project decided to pull the plug because nobody at Marti wanted to develop 
in VO anymore and there was no expertise to maintain Bake-it SQL and 
eventually convert VO to X#... They probably did not think I was able to 
complete the DBF to SQL transition and were waiting for me to fail.... But I 
managed to deliver a fully working, lightning fast Bake-it SQL which nobody 
wanted to maintain...
A pity... It was a nice project.... but now a dead project...

Even more a pity when considering over 400 companies work on a daily basis 
with Bake-it in The Netherlands. IMHO the DBF to SQL transition could be a 
nice step in the future for them especially when Bake-it would be converted 
to X# which would not be that hard since we did not use very exotic stuff in 
our code... And Robert did manage to convert Bake-it to Vulcan in the past 
and showed it in Cologne many years ago....  But VO is now in maintenance 
mode at Marti, nothing new going on and no new people wanting to learn xBase 
/ VO or X#...

Thanx everybody for VO and especially Brian for saving VO from the evil CA, 
Robert for making VO stable and fast, Frans for teaching me VO, Don, Mr. 
Parker, Phil, Paul P, Geoff, Chris, Rod, Dick, Sherlock, Gary, Fabrice, Ed, 
Adriano, Meinhard and all others I forgot to mention... It was nice knowing 
you all!

It was very nice using VO, for me it was a very productive and successful 
product, but those days are over since I only do ASP.Net, C# and VB.Net 
nowadays... I plan to to X# in the future but I am too busy to make time for 
that right now.

Regards, Marc


"D.J.W. van Kooten"  schreef in bericht 
news:fiv2fc9jk415f326n2j12j9156kdgqvh5f@4ax.com...

Replying on message of Fri, 14 Apr 2017 09:04:07 -0700 (PDT) from
Jürgen Knauf:


Hello Jürgen,

>What about C# and SQL Server Express. Any eexperience?
>Can I use it like "ADS Local Server"?

Maybe even with MySQL but I am not sure about that.  I have installed
the MySQL Workbench as this allows me to approach multiple on line
MySQL databases.

Unless there are limitations my first choice would be to go for MySQL,
I would have the same environment for web data and local data and also
because MySQL is not from Microsoft. Here's some comparison:

https://db-engines.com/en/system/Microsoft+SQL+Server%3BMySQL

I think the major problem of SQL when your system is based upon DBF
files is that you can not replace that 1:1 with comparable MySQL
statements. E.g. a DO..WHILE loop replacing a value in a DBF should be
replaced with 1 SQL query in most cases otherwise it's much slower.

Geoff Schaller has written a tool to convert more easily to SQL.

Dick


---
Deze e-mail is gecontroleerd op virussen door AVG.
http://www.avg.com 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Advantage Database server Jürgen Knauf <trotterklaus@googlemail.com> - 2017-04-12 10:38 -0700
  Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-13 09:19 +0200
    Re: Advantage Database server Jürgen Knauf <trotterklaus@googlemail.com> - 2017-04-13 06:21 -0700
  Re: Advantage Database server Martin <Martin@spam.spam> - 2017-04-13 17:09 +0100
  Re: Advantage Database server D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2017-04-13 23:57 +0200
    Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-14 07:55 +0200
    Re: Advantage Database server franslaenen@gmail.com - 2019-12-30 00:37 -0800
      Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2020-01-06 16:55 +0100
  Re: Advantage Database server Sherlock <sherlock@sherlock.com.au> - 2017-04-13 17:42 -0700
    Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-14 07:56 +0200
    Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-14 12:32 +0200
  Re: Advantage Database server Jürgen Knauf <trotterklaus@googlemail.com> - 2017-04-14 09:04 -0700
    Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-14 21:03 +0200
      Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-14 21:29 +0200
        Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-15 09:36 +0200
    Re: Advantage Database server D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2017-04-15 04:13 +0200
      Re: Advantage Database server Franz Rachbauer <office@rachbauer.org> - 2017-04-15 08:34 +0200
      Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-15 09:39 +0200
        Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-15 10:21 +0200
          Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-15 17:49 +0200
            Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-15 18:14 +0200
              Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-15 18:22 +0200
                Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-15 19:29 +0200
                Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-16 05:58 +0200
                Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-16 11:00 +0200
            Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-16 11:55 +0200
              Re: Advantage Database server Sherlock <sherlock@sherlock.com.au> - 2017-04-16 05:36 -0700
                Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-16 21:07 +0200
                Re: Advantage Database server "Rene J. Pajaron" <rjpajaron@gmail.com> - 2017-04-18 04:05 -0700
                Re: Advantage Database server Sherlock <sherlock@sherlock.com.au> - 2017-04-18 05:20 -0700
                Re: Advantage Database server "Rene J. Pajaron" <rjpajaron@gmail.com> - 2017-04-18 05:45 -0700
                Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-18 20:24 +0200
                Re: Advantage Database server "Rene J. Pajaron" <rjpajaron@gmail.com> - 2017-04-18 03:52 -0700
      Re: Advantage Database server "Marc Verkade" <marc@marc.marc> - 2017-04-19 18:00 +0200
        Re: Advantage Database server Sherlock <sherlock@sherlock.com.au> - 2017-04-20 04:57 -0700
        Re: Advantage Database server Jindřich Žák <keivulan@gmail.com> - 2023-10-23 10:22 -0700
  Re: Advantage Database server Jürgen Knauf <trotterklaus@googlemail.com> - 2017-04-14 23:46 -0700
    Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-15 09:42 +0200
  Re: Advantage Database server gloroveo@gmail.com - 2017-04-17 13:32 -0700
  Re: Advantage Database server aib@aib.org.nz - 2017-04-17 17:15 -0700
    Re: Advantage Database server aib@aib.org.nz - 2017-04-17 17:20 -0700
      Re: Advantage Database server James Martin <james@northwoodlumber.com> - 2017-04-18 08:21 -0400
        Re: Advantage Database server Sherlock <sherlock@sherlock.com.au> - 2017-04-18 05:46 -0700
          Re: Advantage Database server James Martin <james@northwoodlumber.com> - 2017-04-18 09:48 -0400
        Re: Advantage Database server aib@aib.org.nz - 2017-04-18 15:21 -0700

csiph-web