How can we help you today? How can we help you today?

Analyze duplication block code

Sometimes, i'll need to refactor some stored procedure and i'm looking for tools to analyze and find a duplication block code.
Because most of the times, lots of dev love copy and paste.
Do you have any idea, it's such tools or functions are existing?

adeangelis31
0

Comments

3 comments

Sort by
  • Tianjiao_Li
    Hi @adeangelis31

    It looks like SQL Search might be able to help in this case https://www.red-gate.com/products/sql-development/sql-search/ 

    Thanks.
    Tianjiao_Li
    0
  • adeangelis31
    I'm disappointed by your answer.
    What i'm look for? It's a tool like Jetbrain analyze duplicate code for sql.
    I have to analyze 1500 stored procedure and view or script code, i was expecting more from redgate.
    adeangelis31
    0
  • Tianjiao_Li
    Hi @adeangelis31

    I'm so sorry about that.

    After speaking to the development team, it doesn't look like we have anything similar to offer at the moment, unfortunately. It would be very helpful if you could kindly post your idea on our user voice forum https://redgate.uservoice.com/forums/94413-sql-prompt 

    We are sorry we couldn't be more help with this particular request, but please do let us know if you have any other questions.
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.