http://idiot-howto.blogspot.co.uk/2008/07/mysql-cast-limitation.html

A simple MySQL query.

select (d.tiny_int*1) as tiny,

(d.small_int*1) as small,

...

Could be pricey...

This looks promising

http://www.red-gate.com/products/sql-development/sql-automation-pack/

We are using SQL Server 2008 (R2) by the way

Thanks for the reply , sounds like a good way forward as I have access to .NET developers. Good to keep costs down as well only need to one licence...

Many thanks for the feedback 😉

This has given me something to think about for sure. We have be deliver an end to end SQL OLTP and OLAP that is not...

Really great feedback , many thanks all for your help 😉