I'd like to accomplish couple things with the Confluence server including upgrade Confluence server from v5.4 to latest version 6.x; migrate Confluence server to a new server with newer version of Windows (MS Servers 2016); and migrate the database from external SQL server to database that running on the same server. While I can find individual steps how to accomplish each of those things but want to make sure what is the proper and possibly less steps.
I also want to know what is the prefer db that simple to manage and run on single server. Our environment is very small of 10 users. We user confluence mainly for document repository.