moodle 1.9.1, MySQL 5.0.something, WIndows XP
New to moodle, don't know MySQL, need to write some programs to access the MySQL database directly from Visual Studio. Will eventually move to MSSQL as that is the site standard, but not yet. Helping a client make their moodle based eLearning system a bit more robust, and as part of that will migrate to latest stable version (1.9.9+).
A few questions:
When I upgrade moodle to 1.9.9+, will the moodle upgrade scripts also upgrade MySQL to 5.5? If not, should I upgrade MySQL to 5.5 myself? What are the moodle considerations for the MySQL version?
What is the best way to do SQL queries, including updates, in MySQL from Visual Studio? I can choose either VS 2008 or 2010. I might need to create tables. I am just reading about something called Connector\NET. Is this a Good Thing for someone like me who is a MySQL ignoramus but familiar with using MSSQL from Visual Studio? Or is there a better approach?
Would appreciate to hear comments or other experiences as this is a new environment to me and it is a short term project.
Also, any recommendations for GUI Interface to MySQL for Database Administrator type stuff like creating tables, doing SQL queries, writing stored procs?