This post has been split into a pillar and five focused posts, each generator script now has its own page with its own real bugs, Example Output, and Related Scripts, rather than five topics crammed into one long post.
Start at the hub: SQL Server Migration Script Generators
- Generate Login Script — SID-preserving CREATE LOGIN DDL, verified with a real throwaway login round trip
- Generate Agent Job Script — job, steps, start step, and schedule DDL, verified with a real job round trip
- Generate User Mapping Script — database user and role DDL, and the real syntax-error bug found testing it live
- Generate Linked Server Script — linked server and login mapping DDL, and the real sys.linked_logins column bug found testing it live
- Generate Restore With Move Script — RESTORE … WITH MOVE DDL, and the real silent path-corruption risk found and fixed testing it live
All five scripts, the repo links, and the “topology you’re migrating into” section are covered in full on the hub and its member pages above. This page stays up so any existing links keep working.
Leave a Reply