Microsoft SQL Server

Information specific to testing with Microsoft SQL Server

Introduction

Microsoft SQL Server is a relational database management system developed by Microsoft.

Configuration

• Supported Database Management Systems: Microsoft SQL Server 2008 R2, Microsoft SQL Server 2012.
• Connecting to and querying a database from a test requires that the correct ODBC driver be used. The correct driver must be specific to both the database application and the architecture (64-bit) of the TestArchitect Controller application that uses it. The following utilities may be used to determine whether the correct driver is already installed:

  • Windows: Open the ODBC Data Source Administrator dialog box. A list of installed ODBC drivers is available under the Drivers tab. (Learn more.)
    
    

  • macOS and Linux: If you do not already have a utility that lists installed ODBC drivers, one good option is the open source project unixODBC.

• Should you need to obtain the ODBC driver installer for your particular data source, following the appropriate link below:
  • Microsoft SQL Server:
    • On Windows: Read here.
    • On Linux: Read here.
    • On macOS: Microsoft does not provide a SQL Server ODBC driver for the macOS machine. However, a good open source alternative, FreeTDS, is available. Note that, additional configurations are also required (learn more).

Actions

TestArchitect provides the following built-in actions for working with SQL-compliant databases. They are listed in the typical order of their workflow:

1. create connection string: Generate a connection string for a specified database on a given host.
2. connect database: Open a database connection using a connection string.
3. use database: Specify a database against which the ensuing SQL action lines are to be applied.
4. execute sql: Execute an SQL command against the currently in-use database; optionally, store returned data into one or more data sets.
5. disconnect database: Close the database connection.

Example

create connection string  

Test Lines



Configuring the ODBC Driver on macOS to connect to Microsoft SQL Server
Explain additional configurations on macOS to connect to Microsoft SQL Server.