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