sqlpackage export data

Question

sqlpackage export data

Indiana 0

Is it possible to export data only of all the tables in the DB using sqlpackage export action? Schema is not to be included in the .bacpac file.

LiHongMSFT-4306 31,621 Reputation points

2024-01-29T02:09:26.5666667+00:00

Hi @Indiana Do you have further question on this issue, could we offer more support? If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

1 answer

Your answer

LiHongMSFT-4306 31,621 Reputation points

2024-01-29T02:09:26.5666667+00:00

Hi @Indiana Do you have further question on this issue, could we offer more support? If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Answer 1

Hi @Indiana Here is an example:

# example export using short form parameter names, skips schema validation
SqlPackage /a:Export /ssn:"{yourserver}.database.windows.net,1433" /sdn:"AdventureWorksLT" /su:"sqladmin" \
    /sp:"{your_password}" /tf:"C:\AdventureWorksLT.bacpac" /p:VerifyExtraction=False

Referring from this doc: SqlPackage Export parameters and properties

Best regards,

Cosmog Hong

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

sqlpackage export data

1 answer

Your answer