You can do this with SSMS.
1 – Right-click your database in Object Explorer.
2 – Select Tasks/Generate Scripts…
3 – On the Set Scripting Options page, click the Advanced button and make sure Types of data to script is set to Data only.
The resulting script will have a USE DATABASE statement at the top. Change this to the database you would like to insert the data into.