It is up to you how you want to transfer data.

There are so many options available

You can use import/export wizard, SSIS, BCP ,script out data and run on other server, Linked server.