/// <summary>
/// Reads a file and updates database names from the config, then loads file the file content into the database.
/// </summary>
private static string ReadAndLoadScript(string sqlFile, string databaseName, string defaultDatabase)
{
log.Info($"Database: {databaseName} Loading {sqlFile}...");
// open file into string
string sqlInputFile = File.ReadAllText(sqlFile);
if (databaseName != defaultDatabase)
{
sqlInputFile = sqlInputFile.Replace(defaultDatabase, databaseName);
}
ResetDatabaseConnection(databaseName);
return(CurrentDb.ExecuteSqlQueryOrScript(sqlInputFile, databaseName, true));
}
