Although SQL Server lacks the necessary capabilities, third-party software exists that does. RedGate used to get something like this, but I believe it was discontinued... although I might be wrong.