I'm pretty sure you can soft solder on nickel with the right flux and solder.
However, soft solder will almost never hold a standard type revolver sight in place.
This is made worse by the "slippery" nature of nickel making solder not adhere to it very well.
Do not attempt to use actual silver solder, which melts at temps above 1100 degrees. This will destroy nickel and most any other finish.
The "silver solder" sold in most stores is actually a soft solder with about 3% silver added to prevent it from tarnishing. This melts at temps around 450 degrees, and is just a soft solder.
Real silver solder is actually silver braze. Depending on the grade it starts to melt around 1100 degrees and requires a special flux specifically made for silver braze.
At the factory, revolver sights are silver soldered into shallow grooves machined in the barrel. The combination of the tight groove and the hard solder hold them in place.
Soft solder just lacks the strength.
About all you can do is give soft solder a try. It'll work better if you have a groove in the barrel that's a very tight fit.