private void CreateDatabase(string scriptFile)
{
SQLServer2005DatabaseConnector database = new SQLServer2005DatabaseConnector(SqlServerHelper.ConnStringHelper);
database.Open();
ClearDatabase(database);
database.RunNonQuerySQL(File.ReadAllText(scriptFile));
database.Close();
}
/// <summary>
/// Creates a new database on the server, dropping the existing one first if it exists.
/// </summary>
public static void CreateDatabaseFiles()
{
ConnectionStringHelper masterConnStringHelper = new ConnectionStringHelper()
{
CurrentDbType = DatabaseTypes.SQLServer2005,
DatabaseName = "master",
ServerName = ".",
UseFileName = false,
UseIntegratedSecurity = true
};
SQLServer2005DatabaseConnector database = new SQLServer2005DatabaseConnector(masterConnStringHelper);
database.Open();
string sql = File.ReadAllText("CreateDatabase - SQL Server.sql");
sql = sql.Replace("[LOCATION]", Path.GetTempPath());
database.RunNonQuerySQL(sql);
database.Close();
}
/// <summary>
/// Creates a new database on the server, dropping the existing one first if it exists.
/// </summary>
public static void CreateDatabaseFiles()
{
ConnectionStringHelper masterConnStringHelper = new ConnectionStringHelper()
{
CurrentDbType = DatabaseTypes.SQLServer2005,
DatabaseName = "master",
ServerName = ".",
UseFileName = false,
UseIntegratedSecurity = true
};
SQLServer2005DatabaseConnector database = new SQLServer2005DatabaseConnector(masterConnStringHelper);
database.Open();
string sql = File.ReadAllText("CreateDatabase - SQL Server.sql");
sql = sql.Replace("[LOCATION]", Path.GetTempPath());
database.RunNonQuerySQL(sql);
database.Close();
}
private void CreateDatabase(string scriptFile)
{
SQLServer2005DatabaseConnector database = new SQLServer2005DatabaseConnector(SqlServerHelper.ConnStringHelper);
database.Open();
ClearDatabase(database);
database.RunNonQuerySQL(File.ReadAllText(scriptFile));
database.Close();
}