SQL Loco

-- вывести всю локализацию которой нету на проде
SELECT  *
FROM    swallow.dbo.as_languageTexts t
WHERE   NOT EXISTS (
                    SELECT  *
                    FROM    swallow_prod.dbo.as_languageTexts t2
                    WHERE   t2.code = t.code
                    AND     t2.langId = t.langId
                    AND     t2.langTextCategoryId = t.langTextCategoryId
                    )

-- и категории
SELECT  *
FROM    swallow.dbo.as_languageTextCategory t
WHERE   NOT EXISTS (
                    SELECT  *
                    FROM    swallow_prod.dbo.as_languageTextCategory t2
                    WHERE   t2.name = t.name
                    )