I assume your cat has a history of struvite crystals and that the c/d hasn't been effective at preventing them? I can't say I know the answer to your question but I can tell you the RX diets formulated to prevent the formation of struvite crystals do so by making the urine more acidic. I can only speculate but it could be that the s/o makes the urine more acid than the c/d and that is why your vet thinks you should switch to it if the c/d hasn't worked. If that is the reason he/she may prefer to try to c/d first because while you want the urine more acidic you don't want it too acidic.
Really you should ask your vet if you really want to know why the switch was suggested.
Also, I hope you know that you must feed the RX food and only the RX food for it to be effective. No treats, no mixing with other foods.
If so, I've only tried Hills products, so I can't say. It seems like each cat is different, so its good that there are 2 brands with urinary lines to find which works best for your cat.
If you mean Hills S/D v Hills C/D, its for slightly different purposes. S/D is meant to break down existing crystals & it only to be fed for a few weeks. C/D is a maintenance food that helps your cat to not form crystals.
As far as I know, the Hill's c/d is supposed to dissolve struvite crystals, while the Royal Canin Urinary SO not only dissolves struvite crystals, but prevents the formation of struvite and calcium oxalate crystals. Our vet carries both, and when our last cat developed struvite crystals, she recommended the RC over the Hill's, but said the latter would be fine if he preferred it (he didn't). She really wanted him on another (German) brand, but he wouldn't eat it.