/// <summary>
/// Creates a blank migration script with the given name.
/// </summary>
/// <param name="migrationName">name of the migration script</param>
/// <returns>The path to the new migration script.</returns>
public string CreateBlankScript(string migrationName)
{
long version = GetNewVersionNumber();
var path = GetPath(null);
path = Path.Combine(path, version + "_" + SanitizeMigrationName(migrationName) + ".sql");
var contents = new MigrationScriptContents(null, null);
var file = new MigrationScriptFile(path);
file.Write(contents);
return path;
}