PokerTracker

I'm thinking of switching from FR cash to SH cash, will i need to make a seperate database for SH? ie, will my hud reconise i'm playing 6max and not show villan stats i might have on them from FR?

You don't need to make a separate database, although if you're making a permanent switch and don't want to see any old data that's certainly an option.
However, you can use the #HUD Options (click for tutorial) to either limit Hud stats to hands played at the current cash limit only, or set up Player Ranges so that you only see stats from short-handed hands when playing short-handed and full ring stats when playing full ring.