Dne středa 19. dubna 2017 v 18:00:21 UTC+2 uživatel Marc Verkade napsal:

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:fiv2fc9jk415f326n...@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

I was interested in your project, but unfortunately it is no longer available. Could you restore the link?

Thank you

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)