apgdiff vs UserFolderMigrator

apgdiff is a free command-line tool that compares two PostgreSQL schema dump files and generates DDL statements to update an older schema or show differences. It takes an original dump and a new dump as inputs; generated SQL can be printed in the terminal or redirected to a file. The project says it can be called from batch jobs or web applications. It is written in Java and requires Java 1.6 or newer. Listed systems include Windows, Linux, Mac OS X, Solaris, and BSD, as well as other systems where Java is available. Version 2.4 is identified as the latest stable release, with binary and source ZIP downloads. Support covers selected ALTER SEQUENCE, ALTER TABLE, ALTER VIEW, COMMENT, CREATE FUNCTION, CREATE INDEX, CREATE SCHEMA, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER, CREATE VIEW, and SET search_path statements. Other SQL statements are ignored, and an option reports ignored DDL. For CREATE TABLE column constraints, only NULL and NOT NULL are supported. The project uses the MIT License and recommends reviewing generated upgrade SQL before applying it.

UserFolderMigrator is a free PowerShell script for Windows shell-folder moves, user-profile backup and restore, and folder redirection management. It can relocate Desktop, Documents, Downloads, Pictures, Music, and Videos, update their registry locations, and optionally remove the originals. Backups can include AppData, Wi-Fi profiles, printers, scheduled tasks, mapped drives, and WSL distributions. Restore proceeds through eight phases for files, registry, access controls, Wi-Fi, mapped drives, scheduled tasks, printers, and WSL distributions. MD5, SHA1, or SHA256 checksums are available, and checkpointing can resume interrupted operations. Dry-run simulates work without changing files or the registry; report-only mode creates HTML and JSON reports without changes. Notifications can go through SMTP, Microsoft Teams webhooks, or remote syslog. The script requires PowerShell 7 or later, Windows 10 or Server 2016 or later, and administrator privileges. The project says it is Windows-only and the main script has no GUI, though an interactive wrapper is included. It is provided under the MIT License.