/// <summary>Snippet for GetDatabaseDdlAsync</summary>
public async Task GetDatabaseDdlAsync()
{
// Snippet: GetDatabaseDdlAsync(DatabaseName,CallSettings)
// Additional: GetDatabaseDdlAsync(DatabaseName,CancellationToken)
// Create client
DatabaseAdminClient databaseAdminClient = await DatabaseAdminClient.CreateAsync();
// Initialize request argument(s)
DatabaseName database = new DatabaseName("[PROJECT]", "[INSTANCE]", "[DATABASE]");
// Make the request
GetDatabaseDdlResponse response = await databaseAdminClient.GetDatabaseDdlAsync(database);
// End snippet
}
/// <summary>Snippet for GetDatabaseDdlAsync</summary>
public async Task GetDatabaseDdlAsync_RequestObject()
{
// Snippet: GetDatabaseDdlAsync(GetDatabaseDdlRequest,CallSettings)
// Create client
DatabaseAdminClient databaseAdminClient = await DatabaseAdminClient.CreateAsync();
// Initialize request argument(s)
GetDatabaseDdlRequest request = new GetDatabaseDdlRequest
{
DatabaseAsDatabaseName = new DatabaseName("[PROJECT]", "[INSTANCE]", "[DATABASE]"),
};
// Make the request
GetDatabaseDdlResponse response = await databaseAdminClient.GetDatabaseDdlAsync(request);
// End snippet
}
public async Task <List <string> > GetDatabaseDdlAsync(string projectId, string instanceId, string databaseId)
{
DatabaseAdminClient databaseAdminClient = await DatabaseAdminClient.CreateAsync();
DatabaseName databaseName = DatabaseName.FromProjectInstanceDatabase(projectId, instanceId, databaseId);
var databaseDdl = await databaseAdminClient.GetDatabaseDdlAsync(databaseName);
var ddlStatements = new List <string>();
Console.WriteLine($"DDL statements for database {databaseId}:");
foreach (var statement in databaseDdl.Statements)
{
Console.WriteLine(statement);
ddlStatements.Add(statement);
}
return(ddlStatements);
}
