internal static string CreateDatabaseScript(string databaseName, string dataFileName, string logFileName, SqlVersion sqlVersion)
{
var builder = new SqlDdlBuilder();
builder.AppendSql("create database ");
builder.AppendIdentifier(databaseName);
if (null != dataFileName)
{
Debug.Assert(logFileName != null, "must specify log file with data file");
builder.AppendSql(" on primary ");
builder.AppendFileName(dataFileName);
builder.AppendSql(" log on ");
builder.AppendFileName(logFileName);
}
// Set READ_COMMITTED_SNAPSHOT ON, if SQL Server 2005 and up and not SQLAzure.
if (sqlVersion >= SqlVersion.Sql9)
{
builder.AppendNewLine();
builder.AppendSql("if serverproperty('EngineEdition') <> 5 alter database ");
builder.AppendIdentifier(databaseName);
builder.AppendSql(" set read_committed_snapshot on");
}
return(builder.unencodedStringBuilder.ToString());
}
internal static string DropDatabaseScript(string databaseName)
{
SqlDdlBuilder sqlDdlBuilder = new SqlDdlBuilder();
sqlDdlBuilder.AppendSql("drop database ");
sqlDdlBuilder.AppendIdentifier(databaseName);
return(sqlDdlBuilder.unencodedStringBuilder.ToString());
}
private static string SetReadCommittedSnapshotScript(string databaseName)
{
SqlDdlBuilder sqlDdlBuilder = new SqlDdlBuilder();
sqlDdlBuilder.AppendSql("alter database ");
sqlDdlBuilder.AppendIdentifier(databaseName);
sqlDdlBuilder.AppendSql(" set read_committed_snapshot on");
return(sqlDdlBuilder.unencodedStringBuilder.ToString());
}
private void AppendCreateSchema(string schema)
{
this.AppendSql("if (schema_id(");
this.AppendStringLiteral(schema);
this.AppendSql(") is null) exec(");
SqlDdlBuilder sqlDdlBuilder = new SqlDdlBuilder();
sqlDdlBuilder.AppendSql("create schema ");
sqlDdlBuilder.AppendIdentifier(schema);
this.AppendStringLiteral(sqlDdlBuilder.unencodedStringBuilder.ToString());
this.AppendSql(");");
this.AppendNewLine();
}
private void AppendCreateSchema(string schema)
{
AppendSql("if (schema_id(");
AppendStringLiteral(schema);
AppendSql(") is null) exec(");
// need to create a sub-command and escape it as a string literal as well...
var schemaBuilder = new SqlDdlBuilder();
schemaBuilder.AppendSql("create schema ");
schemaBuilder.AppendIdentifier(schema);
AppendStringLiteral(schemaBuilder.unencodedStringBuilder.ToString());
AppendSql(");");
AppendNewLine();
}
internal static string CreateDatabaseScript(string databaseName, string dataFileName, string logFileName)
{
var builder = new SqlDdlBuilder();
builder.AppendSql("create database ");
builder.AppendIdentifier(databaseName);
if (null != dataFileName)
{
Debug.Assert(logFileName != null, "must specify log file with data file");
builder.AppendSql(" on primary ");
builder.AppendFileName(dataFileName);
builder.AppendSql(" log on ");
builder.AppendFileName(logFileName);
}
return(builder.unencodedStringBuilder.ToString());
}
internal static string CreateDatabaseScript(
string databaseName,
string dataFileName,
string logFileName)
{
SqlDdlBuilder sqlDdlBuilder = new SqlDdlBuilder();
sqlDdlBuilder.AppendSql("create database ");
sqlDdlBuilder.AppendIdentifier(databaseName);
if (dataFileName != null)
{
sqlDdlBuilder.AppendSql(" on primary ");
sqlDdlBuilder.AppendFileName(dataFileName);
sqlDdlBuilder.AppendSql(" log on ");
sqlDdlBuilder.AppendFileName(logFileName);
}
return(sqlDdlBuilder.unencodedStringBuilder.ToString());
}
