Testing and Microsoft SQL Server

If the application you are testing uses a Microsoft SQL Server database on the back end, then you need the ability to interact with it as directly as possible from QTP.

To do this you must install a SQL-Server client.

You can get one by installing SQL Server 2005 Express which is free and can be found here.

Having done that, the easiest way for QTP to interact with it is using DMO.

DMO (more properly SLQ-DMO) stands for ‘SQL Distributed Management Objects’.

To get DMO you will also need the Microsoft SQL Server 2005 ‘Feature Pack’ here.

Or you can get the DMO bit directly from here.

The great thing about DMO is that is extremely easy to use and very powerful.

I use it in my connection string generator (here).