Export using SQL Server Management Studio (SSMS)
To create a dump from SSMS, right-click a database and select Tasks -> Generate Scripts...
This opens a wizard. In the 'Choose Objects' section select 'Tables':
Open the Advanced options dialog and disable 'Script USE DATABASE' (this lets you import the dumped data into another, differently named, database instance). Set 'Types of data to script' to 'Schema and data':