It will hold up very well. Install a really good controller and use as many of it’s safety features as possible, such as, WOT switch, window switch, fuel pressure safety switch and a nitrous pressure switch. Also use one step colder plugs like NGK 6510s, and good fuel. Keep the shot at 150 hp or less.
Unfortunately, there’s not a lot of info. on this forum regarding nitrous. The info. that I mentioned above is based on my own personal experience with nitrous. Please don’t cut any corners if you decide to install and use it.
Here’s a link to my nitrous install on my Gen 3, which would be no different for your Gen 2. Hopefully it contains enough info. to help you decide if nitrous is for you.