I need to know that flaws make a business level in procedures

Question

In my work, I have a friend who insists on maintaining business logic inside the database using stored procedures ...

What arguments can I use to convince him not to do this?

The reason he wants to do this is because we have several systems with different boards (a .NET web application with VB.NET and another desktop application developed in Power Builder - Sybase).

Thank!

Answer 1

What arguments can I use to convince him not to do this?

What are your arguments against this? Why do you definitely want to stay away from stored procedures?

. , , , - .

Answer 2

- :

• ,
• , ,
• .
• , , , SQL

Answer 3

• .
• , .
• .
• , - -proc, db .
• ,
• , .
• - , .

Edit: other user-contributed points:

• .

Answer 4

-, con:

• , , , . .
• . , , .

Pro, - con:

• , , .
• , , . , .
• - . XML - . , . "" 200 , , SLA .

. , . , , . : . , .

Answer 5

-

, , , . , .

. 5 , . - ...