Sorry to hear.
Unfortunately, it's sometimes hard to say without giving it a few weeks. Our dog living at my moms house, where I lived, HATED Jackson for about 3 weeks. Completely ignored him, would snarl at him, and growl. Eventually they loved each other. Just because Sophie Kate acted this way with one dog does mean she'd be miserable with a puppy. Have hope! Maybe you could adopt an older dog?