Should I be worried about compatibility when replacing my traditional SATA hard drive with a SSD SATA drive?

No. Any standard SATA based SSD will normally work with any SATA based socket.