java.lang.Object
org.odpi.openmetadata.adapters.connectors.mssql.utilities.MSSQLUtils

public class MSSQLUtils extends Object
MSSQLUtils provides simple functions to work with Microsoft SQL Server names and connection strings
  • Constructor Details

    • MSSQLUtils

      public MSSQLUtils()
  • Method Details

    • getDatabaseURL

      public static String getDatabaseURL(String databaseServerURL, String databaseName)
      Convert the connection string for the database server into a connection string for the database. Microsoft SQL Server JDBC URLs identify the target database through a "databaseName" connection property (eg "jdbc:sqlserver://host:port;databaseName=myDatabase") rather than a URL path segment, so any existing databaseName property on the server URL is replaced. The other connection properties (such as encrypt or trustServerCertificate) are kept, wherever they appear in the URL.
      Parameters:
      databaseServerURL - connection string used to connect to the Microsoft SQL Server
      databaseName - name of the database
      Returns:
      connection string