Lightweight migrations are automatic and can handle small changes, complex migrations require manual intervention and can handle more advanced changes.