I was wondering if anybody has used CoreLabs MySql control with StrataFrame.

Mike

I am very interested and in need of MySQL support too.

I agree with what Edhy said about SQL Express too.

If possible, I would VERY much like to use VistaDB (www.VistaDB.net) for the types of Visual FoxPro applications that Edhy is talking about.  I have over 350 VFP laptop users that I want/really need to convert to Strataframe and an SQL database but I don't really want to use SQL Express for all the same reasons Edhy mentioned.  I keep them in VFP for now but I have to bite the bullet and get them off VFP this year for sure.  I will use SQL Express though if necessary.

I am seriously considering using VistaDB because I think it is the ideal replacement for low-end clients like Edhy mentioned and extremely easy to install and maintain - much easier than a VFP client for that matter and it is pretty easy.  If not VistaDB than some other embedded SQL database.

VistaDB is really growing and improving all the time and is 100% MS SQL server compatible.  It is also very inexpensive and recommended by Les Pinter, etc.

Please put my vote in for MySQL Server and VistaDB.  I think others should check out VistaDB and let me know what they think too.

I have some big corporate clients this year who I will use SQL Express for but I hate the huge download size (300MB or more) and the complexities versus using VistaDB or VFP, etc.  I will make it work but and embedded SQL database engine like VistaDB is even better than VFP or SQL Server Express I think.

I would already be using VistaDB if I wasn't so extremely busy and under pressure to meet deadlines and just trying to survice as a startup with limited resources.

Thanks for your consideration.  I really love Strataframe and want to use it for 100% of everything I do.

Russ Brown (Using C#2010/SQL Server 2008)

Hi Russell,



VistaDB looks very interesting but one thing I did not like it is that is a file share database, which means that each application instance needs to open the file database in order to access it, pretty much like VFP and I am not sure I want to go back to that kind of database.



On the other hand I did like all other features, specially their compatibility with MS-SQL which mean that it would probably be easier to implement in SF and our applications to switch from VistaDB to MS-SQL with less code change impact.



What I like about MySQL is that it is a real SQL database,portable and lightweight, reliable, and it can also be embedded and it is available in almost every hosting ISP at a very affordable price for everybody.



I have an application using MS-SQL Express and found out that one of the process needed will be importing thousands of records (sometimes 400,000+) and that those records should be keep in the database for comparison with new imports, that hits me very hard, because now the database file is growing up pretty fast and the only option would be to buy the MS-SQL Standard license and it was just unexpected and that would be the case for almost any customer using this application and that could hurt any possible sale. MySQL is very well suited to handle this application requirements but since it is not supported by SF/DDT/BOM/RBS then it would be very hard for me to manage and I use all SF tools in all applications.

Edhy Rijo