migration: fix sg logger scope, add success messages to up and validate
Created by: bobheadxi
Caught this because it seems sg db reset-pg
needs to be followed by application of migrations in https://github.com/sourcegraph/sourcegraph/pull/38319
Test plan
sg db reset-pg && sg migration up && sg migration validate