when sql2012 or later
SQL:
SELECT db1.name AS sequence_name, db1.current_value as UAT_value, db2.current_value as PROD_value, CONCAT('ALTER SEQUENCE [dbo].[Counter] RESTART WITH ', cast(db2.current_value as varchar(50)), ';') as ALTERATION_SQL
FROM northwind1.sys.sequences AS db1
left join northwind2.sys.sequences db2 on db1.name = db2.name
order by sequence_name