Data blog
Unit testing for databases
Database applications can - and should - benefit from unit tests, but it is surprising how rarely database code is covered by such tests. One of the problems I suppose is with the fact that it can be pretty tricky to write an isolated test that does not modify the state of the system, so it is fully re-runnable and yields the same results each time. Martin Fowler wrote a good article discussing the unit tests concept - well worth having a look at!
Read more
How to install MySQL Connection Provider
SelectCompare can connect any ODBC or OLEDB data source. You only need to install the data provider, and when it has been installed, you can use SelectCompare to connect to the respective database and compare its data with any other data set that you wish.
There are several different OLEDB providers for MySQL. In this example, I will use an older, but still popular provider implemented by Cherry City Software.