I would agree with @rjcup3 for the most part, but if your site has no customizations then you do have a chance of being able to upgrade it without requiring a third party tool (DocAve, Quest, etc..).
- Make sure your 2007 site is patched at least to SP2
- run the
stsadm -o pregupgradecheck command on the server to get a
feel for how much you will need to change / clean in order to get to 2010
- If that is clean then you will need to copy of your content database
over from 2007 and attach it to 2010 via the command line (not the UI). This will kick off the second
half of the upgrade process and show you the remaining problem areas
- If both the preupgradecheck and the attach are clean then you might
be able to do a simple detach, copy, attach upgrade
However, 2010 does come with its own pains :
- The single most time consuming issue so far has been dealing with lists
that have over 5000 items since 2010 introduces list view thresholds
that throttle views to 5,000 items. There are a number of strategies
for handling large lists but there is no 'magic bullet' (aside from
turning throttling off entirely and gambling with server performance)
- 2010 also introduces the Ribbon which will take some time to train
your users on
- From an admin perspective, 2010 also does away with the Shared
Service Provider so you will need to spend some time configuring
search, user profiles and the like
In the case of my current client, we used a third party tool (DocAve) to migrate content from 2003 to 2007 but then used the content database detach/attach method to go from 2007 to 2010 and that has worked out well for them.