• 1 time transfer or continuous transfer?

    1 time, use import export data wizard, SSIS, BCP etc

    continuous I would look at replication