Added integration tests
Added reference to sql transport and made it the default