Scripts Folder Stored Procedure Identical Name issue
I am attempting to create a scripts folder of a DB that will be added to source control (TFVC). The Sync fails b/c there are several SP that SQL Compare is telling me have identical names. These SP are named the same but are appended with a number; for example sp_GetBillingInfo.sql, sp_GetBillingInfo1.sql and sp_GetBillingInfo2.sql. While versions one and two are very similar to GetBillingInfo they are used at different times and are unique.
With that said how to get SQL Compare to understand that these SP are different? I understand that could force the dev team rename the SP to a more appropriate name like sp_GetBillingInfo4Step1.sql instead of sp_GetBillingInfo1.sql. I may try this but I also want to know if there are any other options for me.