Simple way to export and import data in SQL Server
Right Click DatabaseName -> Go to Task -> Generate Script
One dialog is open

1). Select ALL Table &amp; Click on Next

2). Click on Advance Select  button and select value "Data only" in Type data to Script dropdown

3). And Click Finish

4). Copy result .sql file to target machine.

5). run resultant .sql file to target machine.