IPrimaryMsSqlSPLD.DatabaseOnly

Syntax

DatabaseOnly: String;

Description

The DatabaseOnly property determines an identifier of the database on the MS SQL server, in which repository data is stored.

Comments

The property can be used if the Microsoft SQL Server 2008 DBMS type is on the server and a user schema is used in database.

The DatabaseOnly property provides only database identifier without user schema.

Example

To execute the example, add the Metabase system assembly to the unit.

Sub UserProc;
Var
    MbMan: IMetabaseManager;
    MbDefs: IMetabaseDefinitions;
    MbDef: IMetabaseDefinition;
    MsSqlSPLD: IPrimaryMsSqlSPLD;
Begin
    MbMan := MetabaseManagerFactory.Active;
    MbDefs := MbMan.Definitions;
    MbDef := MbDefs.Add;
    MbDef.DriverId := "MSSQL2008";
    MbDef.Id := "Test_MSSQL";
    MbDef.Name := "Test_MSSQL";
    MbDef.Authentication := AuthenticationMode.Password;
    MbDef.SecurityPackage := "STANDARDSECURITYPACKAGE";
    MsSqlSPLD := MbDef.LogonData As IPrimaryMsSqlSPLD;
    MsSqlSPLD.Server := "Test_MS";
    MsSqlSPLD.DatabaseOnly := "DB_Repository";
    MsSqlSPLD.SchemaOnly := "UserSchema";
    MbDef.Save;
End Sub UserProc;

After executing the example a new description of the repository is created. The UserSchema user schema in the specified database is used for connection. The MS SQL Server 2008 DBMS is used on the Test_MS server.

See also:

IPrimaryMsSqlSPLD