No you do not need SDE. Positions will create a mobile cache of your data, utilizing Project Manager. You then synchronize your cache back into the database. Positions requires a file geodatabase. As long as you are up to date on your maintenance with Correct and Analyst, you can convert for free, just contact your Trimble dealer/reseller.