0

Trying to copy a database from a hosted server to a local server for testing purposes and am trying to avoid exporting the whole database as a .bacpac file as there are some tables with tens, maybe hundreds of thousands of rows.

I've tried looking for ways to export the database as a .bacpac file using only the top X rows of each database without luck. I have similarly had little luck with exporting the database as a .dacpac file and then transferring a select amount of data between the hosted and local servers.

Improve this question
2
  • BACPAC will only copy the schema and data or the tables that you select in the wizard. For your need, there is no straight solution, you need to export only the schema via Generate scripts, after that select top 10 or 100 records from each of your table, and then use BCP utility to get imported into your new db.
    – Anand Sowmithiran
    Commented May 31, 2023 at 15:41
  • Shame, I was afraid of that. Also not sure why I got a downvote.
    – Maen Enma
    Commented May 31, 2023 at 15:44

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.