What is the difference between these two options? (Export\Extract)

TIA,

edm2

Hi edm2,

Exporting a database creates a BACPAC file. This contains both schema and data. Extracting a database creates a DACPAC file which only has schema. 

A DACPAC is generally used for deploying schema to a test, development or production environment. A BACPAC is generally used for migrating a database in and out of Azure SQL Database or to other servers.

You can learn more about Data-tier applications here.

Regards,

-Eli

• Edited by Eli FisherMicrosoft employee 8 hours 17 minutes ago
• Proposed as answer by Casey KarstMicrosoft employee, Moderator 7 hours 39 minutes ago

Hi edm2,

Exporting a database creates a BACPAC file. This contains both schema and data. Extracting a database creates a DACPAC file which only has schema. 

A DACPAC is generally used for deploying schema to a test, development or production environment. A BACPAC is generally used for migrating a database in and out of Azure SQL Database or to other servers.

You can learn more about Data-tier applications here.

Regards,

-Eli

• Edited by Eli FisherMicrosoft employee 8 hours 5 minutes ago
• Proposed as answer by Casey KarstMicrosoft employee, Moderator 7 hours 26 minutes ago

Hi edm2,

Exporting a database creates a BACPAC file. This contains both schema and data. Extracting a database creates a DACPAC file which only has schema. 

A DACPAC is generally used for deploying schema to a test, development or production environment. A BACPAC is generally used for migrating a database in and out of Azure SQL Database or to other servers.

You can learn more about Data-tier applications here.

Regards,

-Eli

• Edited by Eli FisherMicrosoft employee Thursday, August 20, 2015 11:03 PM
• Proposed as answer by Casey KarstMicrosoft employee, Moderator Thursday, August 20, 2015 11:42 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator 16 hours 18 minutes ago

Hi edm2,

Exporting a database creates a BACPAC file. This contains both schema and data. Extracting a database creates a DACPAC file which only has schema. 

A DACPAC is generally used for deploying schema to a test, development or production environment. A BACPAC is generally used for migrating a database in and out of Azure SQL Database or to other servers.

You can learn more about Data-tier applications here.

Regards,

-Eli

• Edited by Eli FisherMicrosoft employee Thursday, August 20, 2015 11:03 PM
• Proposed as answer by Casey KarstMicrosoft employee, Moderator Thursday, August 20, 2015 11:42 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator 16 hours 28 minutes ago

Hi edm2,

Exporting a database creates a BACPAC file. This contains both schema and data. Extracting a database creates a DACPAC file which only has schema. 

A DACPAC is generally used for deploying schema to a test, development or production environment. A BACPAC is generally used for migrating a database in and out of Azure SQL Database or to other servers.

You can learn more about Data-tier applications here.

Regards,

-Eli

• Edited by Eli FisherMicrosoft employee Thursday, August 20, 2015 11:03 PM
• Proposed as answer by Casey KarstMicrosoft employee, Moderator Thursday, August 20, 2015 11:42 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator Friday, August 21, 2015 2:49 PM

Hi edm2,

Exporting a database creates a BACPAC file. This contains both schema and data. Extracting a database creates a DACPAC file which only has schema. 

A DACPAC is generally used for deploying schema to a test, development or production environment. A BACPAC is generally used for migrating a database in and out of Azure SQL Database or to other servers.

You can learn more about Data-tier applications here.

Regards,

-Eli

• Edited by Eli FisherMicrosoft employee Thursday, August 20, 2015 11:03 PM
• Proposed as answer by Casey KarstMicrosoft employee, Moderator Thursday, August 20, 2015 11:42 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator Friday, August 21, 2015 2:49 PM

Excellent answer Eli. I am generally familiar with BACPAQ vs DACPAC but didn't realize how they were generated using the options mentioned above!

edm2