Migrating Data into SQL Database
A number of options exist for importing existing SQL Server (and other platform) data into SQL Database. They include the following:
Executing a T-SQL script that includes object declarations and data insertion statements. You can create these scripts using the Generate and Publish Scripts Wizard, launched by right-clicking a standard SQL Server database in SSMS and then choosing Tasks, Generate Scripts.
Importing a data-tier application export package (DACPAC) file (covered later in the section, “Backing Up and ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
