Redgate Test Data Manager

Database connection string formats

For different types of connection strings explained in full, please visit https://www.connectionstrings.com 

Here are some examples of connection string formats, however these are not exhaustive. 

SQL Server

  1. "Server=[myServerName];Database=[myDatabase];User Id=[myUsername];Password=[myPassword];Trust Server Certificate=true;"

PostgreSQL

  1. "host=[myServerName];Port=[myPortNumber];Database=[myDatabase];User Id=[myUsername];Password=[myPassword];"

MySQL

  1. "Server=[myServerName];Database=[myDatabase];Uid=[myUsername];Pwd=[myPassword];"

Oracle

  1. "DATA SOURCE=[myServerName]/[myDatabase];USER ID=[myUsername];PASSWORD=[myPassword];"

Didn't find what you were looking for?