Event Sourcing versus Database Per Service when building microservices?

hey evryone im tryin to wrap my head around the best way to manage data consistency across microservices. ive been lookin into event sourcin as a way to achieve this, where each service emits events that others subscribe to. on the other hand, the database per service pattern is also popular, with services communicatin via apis or message queues. whats ur experiences with these approaches? r there specific scenarios where one clearly shines over the other? im particularly interested in the operational overhead and complexity of each