getDatabase

Use this data source to access information about an existing SQL database.

Example Usage

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.mssql.Server;
import com.pulumi.azure.mssql.ServerArgs;
import com.pulumi.azure.mssql.MssqlFunctions;
import com.pulumi.azure.mssql.inputs.GetDatabaseArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var exampleResourceGroup = new ResourceGroup("exampleResourceGroup", ResourceGroupArgs.builder()
.location("West Europe")
.build());
var exampleServer = new Server("exampleServer", ServerArgs.builder()
.resourceGroupName(exampleResourceGroup.name())
.location(exampleResourceGroup.location())
.version("12.0")
.administratorLogin("4dm1n157r470r")
.administratorLoginPassword("4-v3ry-53cr37-p455w0rd")
.build());
final var exampleDatabase = MssqlFunctions.getDatabase(GetDatabaseArgs.builder()
.name("example-mssql-db")
.serverId(exampleServer.id())
.build());
ctx.export("databaseId", exampleDatabase.applyValue(getDatabaseResult -> getDatabaseResult).applyValue(exampleDatabase -> exampleDatabase.applyValue(getDatabaseResult -> getDatabaseResult.id())));
}
}

Return

A collection of values returned by getDatabase.

Parameters

argument

A collection of arguments for invoking getDatabase.


suspend fun getDatabase(name: String, serverId: String): GetDatabaseResult

Return

A collection of values returned by getDatabase.

See also

Parameters

name

The name of the MS SQL Database.

serverId

The id of the MS SQL Server on which to read the database.


suspend fun getDatabase(argument: suspend GetDatabasePlainArgsBuilder.() -> Unit): GetDatabaseResult

Return

A collection of values returned by getDatabase.

See also

Parameters

argument

Builder for com.pulumi.azure.mssql.kotlin.inputs.GetDatabasePlainArgs.