If this is a onetime (or two time, test and then production) data transfer, you could probably get a way with the Import Data wizard in SSMS. If you will need to schedule and possibly fine tune your migration (as is in my mind likely) you should use SSIS. There are migration wizards within that can automate the creation of the initial package(s), but you will most likely need to modify them afterwards.