There is an existing lease on a property. How is the lease transferred at closing?

The Title Company is responsible to collect the security deposit from the Seller's proceeds as it'll become the responsibility of the Buyer to release the security deposit to the Tenant at the end of the lease.