Now trying out MySQL. Results later.
As mentioned before I basically want a HIGH performance yet portable database.
For a portable MySQL i downloaded the noinstall zip file from mysql downloads for windows and just extracted it to a folder.
PS: I only downloaded the 32 bit version and ran it on 64 bit. It runs fine. I did this because of easier distribution and lesser user headache.
Just downloaded the zip mysql-connector-net-6.2.2.zip from my sql site and installed the MSI therein. Awesome!
As a service
Just install MySQL as a service by running
And start the service using: net start mysql
Stop the service using:
net stop mysql
and Uninstall the service:
As a standalone server
Tracking down failure in a service can be tricky. You can start the standalone version using :
If it is running this way you can shut it down using the following:
msyqladmin -u root shutdown
I went with the standalone server since it need to run it embedded :)
Setting up VS 2008 Connection Dialog
- Just select MySQL Database as you datasource.