Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
F/S to C/S Help
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01644874
Message ID:
01645031
Views:
48
>Jeff,
>
>I think i'll play with MySQL to learn basics but you may be right. Probably will tell client to go with MS SQL. I am gathering info first before I attempt the conversion.
>
>Thanks,
>
>Bill

Yes, I guess playing with MySQL won't hurt that much. However, you could download a free version of MS SQL Server and later purchase the Standard version of MS SQL.

I work with both MySQL and MSSQL. I strongly prefer MSSQL.

Again, I've had horrible backup and restore problems with MySQL where the bin log refused to restore. I know you don't know what a "bin log" is, but it is critical in your restore process. I don't have those kinds of restore problems in MSSQL.

Also, I can restore MSSQL database of 30 GB in about 15 minutes. For an 8 GB database in MySQL it takes an hour.

I'm writing a lot on backup and restore here because I suspect you will become the accidental DBA who will be responsible for backup and restore in the event of an accident. I would urge you to focus on MS SQL and specifically https://ola.hallengren.com/ for some great utilities for backup. Also, check out Brent Ozar's SQL Blitz and his columns on how to configure your SQL server to best practices.

Maybe Kevin Goff might add something about MSSQL vs. MySQL and backup and configuration.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform