// Private methods
private List <SqlServerScript> CreateOtherObjectsFromScripts(string scriptsRootFolderPath)
{
List <string> otherObjectsScriptsFolders =
new List <string>
{
"Stored Procedures",
"Triggers",
"User Defined Functions",
"Views"
};
IEnumerable <string> otherObjectsScriptsFolderPaths =
(from folder in otherObjectsScriptsFolders
select Path.Combine(scriptsRootFolderPath, folder));
return(SqlServerScriptExecutor.ExecuteScriptsInFolders(otherObjectsScriptsFolderPaths, this, null));
}
private List <SqlServerScript> CreateUserDefinedDataTypesFromScripts(string scriptsRootFolderPath)
{
string userDefinedDataTypesScriptsFolderPath = Path.Combine(scriptsRootFolderPath, "User Defined Data Types");
return(SqlServerScriptExecutor.ExecuteScriptsInFolder(userDefinedDataTypesScriptsFolderPath, this, 0));
}
private List <SqlServerScript> CreateTablesFromScripts(string scriptsRootFolderPath)
{
string tableScriptsFolderPath = Path.Combine(scriptsRootFolderPath, "Tables");
return(SqlServerScriptExecutor.ExecuteScriptsInFolder(tableScriptsFolderPath, this, 1));
}
private List <SqlServerScript> CreateSynonymsFromScripts(string scriptsRootFolderPath)
{
string synonymsScriptsFolderPath = Path.Combine(scriptsRootFolderPath, "Synonyms");
return(SqlServerScriptExecutor.ExecuteScriptsInFolder(synonymsScriptsFolderPath, this, 0));
}