/// <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)); }