I don't have such long procedures and I wouldn't want to have one because it'll be hard to maintain. You can check APEX support forum and even post your question there.

> I tried the 14 day trial of APEX SQL Diff . I have problem with Long Store procedure about 2500 lines . I found out that APEX cannot Detect it and exclude it on the list after scan. so cannot compare it. It this the normal behaviour? have you try to sync long store procedure in APEX?