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