Analyze duplication block code

adeangelis31

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?

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.

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.

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.