You can get the Heide Knight sword by completing a quest in the game called The Heide Knight