Principal Program Manager at the .NET product Group (Microsoft Corp in Redmond, Seattle). Focus on Machine Learning .NET (ML.NET), .NET Core, Microservices based architecture, Docker Containers, Azure services.
The basic way: SQL Scripts + BCP
There are also other methods you can use to export/import or even sync data like SQL Azure Migration Wizard, SQL Azure Data Sync, and even SSIS (SQL Server Integration Services).
Also, instead of creating database schema using SQL Scripts, another new option is using the new DACPAC (Data Tier Packages), in ...