sqlmigration-objects-reviewlisted

Audits the operational-object migration plan for a SQL Server move with 16 checks (M1-M16) — SQL Agent jobs/operators/alerts/proxies, linked servers, Database Mail, backup devices, custom error messages, server-level triggers, Extended Events sessions, and endpoints. Use this skill when a user is migrating a SQL Server instance and needs to carry over scheduled jobs, linked servers, mail profiles, or other instance-level objects, or asks "what instance objects do I need to recreate after migration." Trigger whenever operational-object portability during a migration is the topic; dispatched here from /sqlmigration-review for the operational-object family.
vanterx/mssql-performance-skills · ★ 5 · API & Backend · score 77

Install: claude install-skill vanterx/mssql-performance-skills

# sqlmigration-objects-review ## Purpose Reviews the operational-object family of a SQL Server migration — the slice `sqlmigration-review` dispatches here rather than checking itself. This skill owns 16 checks (M1–M16) covering whether instance-level operational objects survive a backup/restore or log shipping/Always On AG seeding migration, since none of these objects travel with a database backup/restore — they live in `msdb`/`master` at the instance level and must be migrated separately. - **SQL Agent (M1–M6)** — jobs referencing the wrong database, job owner login missing, operators with stale notification addresses, alerts tied to error numbers not raised on target, proxy account credential mapping, job schedule timezone drift - **Linked Servers (M7–M9)** — provider availability on target, data source connectivity, collation-compatible setting - **Database Mail (M10–M11)** — mail profile/account not migrated, SMTP relay allow-list missing the new instance - **Backup Infrastructure (M12)** — backup device path unreachable from target - **Custom Errors (M13)** — `sys.messages` custom error definitions not migrated - **Server Triggers (M14)** — server-level DDL/logon triggers not migrated - **XE Sessions (M15)** — Extended Events session definitions not migrated - **Endpoints (M16)** — non-AG endpoints (Service Broker, SOAP legacy) not migrated All fix recipes use native T-SQL system objects/scripts, the in-box `SqlServer` PowerShell module, and `sqlcmd`/`bcp` —