/// <summary>
/// Script all objects on the server excluding the defined databases
/// </summary>
/// <param name="c">Connection Details</param>
/// <param name="ExcludeDB">List of Databases ot exclude</param>
public void ScriptEverything(SQLServerScripterConnection c, List <string> ExcludeDB)
{
if (ExcludeDB == null)
{
throw new Exception("ExcludeDB cannot be null");
}
m_Server = c.Server;
var Excludes = m_DBExceptionList.Concat(ExcludeDB);
//
// Setup connection
//
ServerConnection conn = new ServerConnection();
if (c.User != null)
{
conn.LoginSecure = false;
conn.Login = c.User;
conn.Password = c.Password;
}
else
{
conn.LoginSecure = true;
}
conn.ServerInstance = m_Server;
Server srv = new Server(conn);
ScriptLogins(srv.Logins);
ScriptSQLAgentJobs(srv.JobServer);
var databases = from Database db in srv.Databases
where !Excludes.Contains(db.Name)
select db;
foreach (Database d in databases)
{
ScriptDatabase(d);
ScriptUsers(d);
ScriptSchemas(d);
ScriptDatabaseRoles(d);
ScriptApplicationRoles(d);
ScriptTables(d);
ScriptViews(d);
ScriptProcs(d);
ScriptFunctions(d);
ScriptSynonyms(d);
ScriptTypes(d);
ScriptDataTypes(d);
ScriptTableTypes(d);
}
}
/// <summary>
/// Script all objects on the server
/// </summary>
/// <param name="c">Connection Details</param>
public void ScriptEverything(SQLServerScripterConnection c)
{
ScriptEverything(c, new List <string> {
});
}
