Read .sql file into a database
Do you want to move data as a one off exercise or do you want to add the data to source control?

SSMS Tools Pack includes a script generator for resultsets, tables or databases.
SSMS has table level data script generation built-in.
If the datasets are large, consider using BCP.
SSIS Import/Export wizard