I was asked to automatically script tables as INSERTs so we could check them in.
Surely it’s easy…
1. mssql-scripter - dead,”use SSMS”. :(
2. Sqlpackage extract - tabledata doesn’t seem to work, if it did maybe generate parquet?
Phil Factor (RIP) to the rescue with a script from 2012. #sqlserver
Surely it’s easy…
1. mssql-scripter - dead,”use SSMS”. :(
2. Sqlpackage extract - tabledata doesn’t seem to work, if it did maybe generate parquet?
Phil Factor (RIP) to the rescue with a script from 2012. #sqlserver
September 18, 2025 at 7:30 PM
I was asked to automatically script tables as INSERTs so we could check them in.
Surely it’s easy…
1. mssql-scripter - dead,”use SSMS”. :(
2. Sqlpackage extract - tabledata doesn’t seem to work, if it did maybe generate parquet?
Phil Factor (RIP) to the rescue with a script from 2012. #sqlserver
Surely it’s easy…
1. mssql-scripter - dead,”use SSMS”. :(
2. Sqlpackage extract - tabledata doesn’t seem to work, if it did maybe generate parquet?
Phil Factor (RIP) to the rescue with a script from 2012. #sqlserver
Thanks! 1 and 3 are practically difficult and 2 is a hallucination. Re:1 I found some old SOs but really unsure whether still valid and how it might integrate into sqlpackage
September 3, 2025 at 6:18 PM
Thanks! 1 and 3 are practically difficult and 2 is a hallucination. Re:1 I found some old SOs but really unsure whether still valid and how it might integrate into sqlpackage
New release of DacFX and SqlPackage (for automating SQL Database Projects) - adds the ability to ignore post and pre deploy scripts during deployment
#dotnet #dacfx
#dotnet #dacfx
DacFx and SqlPackage Release Notes - SQL Server
Release notes for Microsoft SqlPackage.
buff.ly
August 1, 2025 at 1:36 PM
"Lesson Learned #523: Measuring Import Time -Parsing SqlPackage Logs with PowerShell" buff.ly/mzk4p5i #Microsoft #techcommunity
Lesson Learned #523: Measuring Import Time -Parsing SqlPackage Logs with PowerShell | Microsoft Community Hub
This week I'm working on a service request who was experiencing long import times when restoring a large BACPAC into Azure SQL Database, I need to understand...
buff.ly
June 10, 2025 at 2:32 PM
"Lesson Learned #523: Measuring Import Time -Parsing SqlPackage Logs with PowerShell" buff.ly/mzk4p5i #Microsoft #techcommunity
Check out the recently released updates to the #SqlPackage and the #DacFx ecosystem! They're pretty cool!
techcommunity.microsoft.com/blog/azuresq...
#Microsoft #SQLServer #SSDT #AzureSQL #Azure #MadeiraData #DevOps
techcommunity.microsoft.com/blog/azuresq...
#Microsoft #SQLServer #SSDT #AzureSQL #Azure #MadeiraData #DevOps
Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub
The quarterly release cadence for SqlPackage and DacFx continues with the 170.0 release in mid-April 2025. Recent releases to SqlPackage and DacFx ecosystem...
techcommunity.microsoft.com
May 11, 2025 at 10:01 AM
Check out the recently released updates to the #SqlPackage and the #DacFx ecosystem! They're pretty cool!
techcommunity.microsoft.com/blog/azuresq...
#Microsoft #SQLServer #SSDT #AzureSQL #Azure #MadeiraData #DevOps
techcommunity.microsoft.com/blog/azuresq...
#Microsoft #SQLServer #SSDT #AzureSQL #Azure #MadeiraData #DevOps
Recently released: Updates to the SqlPackage and the DacFx ecosystem by Drew Skwiers-Koballa #AzureSQLDatabase techcommunity.microsoft.com/t5/azure-sql...
Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub
The quarterly release cadence for SqlPackage and DacFx continues with the 170.0 release in mid-April 2025. Recent releases to SqlPackage and DacFx ecosystem...
techcommunity.microsoft.com
May 10, 2025 at 1:10 PM
Recently released: Updates to the SqlPackage and the DacFx ecosystem by Drew Skwiers-Koballa #AzureSQLDatabase techcommunity.microsoft.com/t5/azure-sql...
Reading: Recently released: Updates to the #SqlPackage and the #DacFx ecosystem #AzureData #AzureSQL #SQLServer
Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub
The quarterly release cadence for SqlPackage and DacFx continues with the 170.0 release in mid-April 2025. Recent releases to SqlPackage and DacFx ecosystem...
techcommunity.microsoft.com
May 7, 2025 at 4:41 PM
Reading: Recently released: Updates to the #SqlPackage and the #DacFx ecosystem #AzureData #AzureSQL #SQLServer
Recently released: Updates to the SqlPackage and the DacFx ecosystem - JSON and VECTOR data types support, parquet support (still in progress), unpack and compare.
buff.ly/gqziNOk
#dotnet #sqlserver
buff.ly/gqziNOk
#dotnet #sqlserver
Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub
The quarterly release cadence for SqlPackage and DacFx continues with the 170.0 release in mid-April 2025. Recent releases to SqlPackage and DacFx ecosystem...
buff.ly
April 30, 2025 at 1:36 PM
Recently released: Updates to the SqlPackage and the DacFx ecosystem - JSON and VECTOR data types support, parquet support (still in progress), unpack and compare.
buff.ly/gqziNOk
#dotnet #sqlserver
buff.ly/gqziNOk
#dotnet #sqlserver
"Recently released: Updates to the SqlPackage and the DacFx ecosystem" techcommunity.microsoft.com/blog/AzureSQ... #Microsoft #techcommunity
Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub
The quarterly release cadence for SqlPackage and DacFx continues with the 170.0 release in mid-April 2025. Recent releases to SqlPackage and DacFx ecosystem...
techcommunity.microsoft.com
April 29, 2025 at 4:15 PM
"Recently released: Updates to the SqlPackage and the DacFx ecosystem" techcommunity.microsoft.com/blog/AzureSQ... #Microsoft #techcommunity
.... sorry really late seeing this. Which SqlPackage install is it removing? (msi, zip, or dotnet tool?)
April 28, 2025 at 6:56 PM
.... sorry really late seeing this. Which SqlPackage install is it removing? (msi, zip, or dotnet tool?)
For the SQL server, a script/run block can call sqlpackage directly. The azuredacpac deploy task requires the azure subscription and I believe won’t even deploy to a sql server vm in azure (on the list of things to fix asap)
April 28, 2025 at 3:49 PM
For the SQL server, a script/run block can call sqlpackage directly. The azuredacpac deploy task requires the azure subscription and I believe won’t even deploy to a sql server vm in azure (on the list of things to fix asap)
If you do a dacpac deployment (which you get after building a database project in VS), sqlpackage will do a schema compare against the target and deploy changes.
April 2, 2025 at 5:29 PM
If you do a dacpac deployment (which you get after building a database project in VS), sqlpackage will do a schema compare against the target and deploy changes.
Curious how #sqlfamily is doing Ci/CD. I’ve checked our DDL into GitHub. How do I get from dev to prod? If I change a table and add a permission, what scripts out the changes from my dev DB? Redgate? Sqlpackage? VS Db Proj? Is there a Best Practice/Guide somewhere? #sqlserver
April 1, 2025 at 6:01 PM
Curious how #sqlfamily is doing Ci/CD. I’ve checked our DDL into GitHub. How do I get from dev to prod? If I change a table and add a permission, what scripts out the changes from my dev DB? Redgate? Sqlpackage? VS Db Proj? Is there a Best Practice/Guide somewhere? #sqlserver
Postgres doesn’t have a sqlpackage tool because Postgres folks are used to working with migrations based deployment approaches. Many of us find it superior and a better approach. People tend to be biased based on what they are used to. 🤷🏻♀️
March 24, 2025 at 9:21 PM
Postgres doesn’t have a sqlpackage tool because Postgres folks are used to working with migrations based deployment approaches. Many of us find it superior and a better approach. People tend to be biased based on what they are used to. 🤷🏻♀️
SQLPackage CLI is my goto. learn.microsoft.com/en-us/sql/to...
SqlPackage CLI reference - SQL Server
Learn how to use SqlPackage with its CLI syntax. View available parameters, properties, and SQLCMD variables.
learn.microsoft.com
March 2, 2025 at 4:31 PM
SQLPackage CLI is my goto. learn.microsoft.com/en-us/sql/to...
Any Data folk been able to get sqlpackage installed on a VMSS Azure DevOps Build Agent?
Sysprep removes the installation when generating an image.
Needs to be available for the SqlAzureDacpacDeployment@1 task to use.
#sqlfamily #sqlhelp
Sysprep removes the installation when generating an image.
Needs to be available for the SqlAzureDacpacDeployment@1 task to use.
#sqlfamily #sqlhelp
February 11, 2025 at 1:29 PM
Any Data folk been able to get sqlpackage installed on a VMSS Azure DevOps Build Agent?
Sysprep removes the installation when generating an image.
Needs to be available for the SqlAzureDacpacDeployment@1 task to use.
#sqlfamily #sqlhelp
Sysprep removes the installation when generating an image.
Needs to be available for the SqlAzureDacpacDeployment@1 task to use.
#sqlfamily #sqlhelp
Esportare Multiple Basi Dati Simultaneamente con SqlPackage: Scopri come esportare più basi dati contemporaneamente utilizzando SqlPackage e ottimizzare le prestazioni del trasferimento dei dati. Negli ultimi giorni, mi sono dedicato a un caso di assistenza che richiedeva l’esportazione di più basi…
Esportare Multiple Basi Dati Simultaneamente con SqlPackage
Scopri come esportare più basi dati contemporaneamente utilizzando SqlPackage e ottimizzare le prestazioni del trasferimento dei dati. Negli ultimi giorni, mi sono dedicato a un caso di assistenza che richiedeva l’esportazione di più basi dati utilizzando…
www.remoteitalia.com
June 17, 2024 at 10:04 AM
Esportare Multiple Basi Dati Simultaneamente con SqlPackage: Scopri come esportare più basi dati contemporaneamente utilizzando SqlPackage e ottimizzare le prestazioni del trasferimento dei dati. Negli ultimi giorni, mi sono dedicato a un caso di assistenza che richiedeva l’esportazione di più basi…
Le Novità di SqlPackage: Controllare e Ottimizzare il Deployment: Rilasci recenti di SqlPackage offrono nuove funzioni per ottimizzare la gestione di indici e la portabilità dei dati in ambiente Azure. Il mondo dei database si evolve costantemente, con nuove funzioni che miglioreranno la gestione e…
Le Novità di SqlPackage: Controllare e Ottimizzare il Deployment
Rilasci recenti di SqlPackage offrono nuove funzioni per ottimizzare la gestione di indici e la portabilità dei dati in ambiente Azure. Il mondo dei database si evolve costantemente, con nuove funzioni che miglioreranno la gestione e il deployment di…
www.remoteitalia.com
February 29, 2024 at 11:04 AM
Le Novità di SqlPackage: Controllare e Ottimizzare il Deployment: Rilasci recenti di SqlPackage offrono nuove funzioni per ottimizzare la gestione di indici e la portabilità dei dati in ambiente Azure. Il mondo dei database si evolve costantemente, con nuove funzioni che miglioreranno la gestione e…
Hi all, since got asked about this yesterday just want to highlight that this repo to perform CI/CD for #MicrosoftFabric Data Warehouses using and #AzureDevOps highlights fact that you should install SQLPackage first if using a #Microsoft hosted agent.
github.com/kevchant/Azu...
github.com/kevchant/Azu...
GitHub - kevchant/AzureDevOps-FabricDWDBProject: Template to perform CI/CD for Microsoft Fabric Data...
Template to perform CI/CD for Microsoft Fabric Data Warehouses - GitHub - kevchant/AzureDevOps-FabricDWDBProject: Template to perform CI/CD for Microsoft Fabric Data Warehouses
github.com
November 28, 2023 at 9:55 AM
Hi all, since got asked about this yesterday just want to highlight that this repo to perform CI/CD for #MicrosoftFabric Data Warehouses using and #AzureDevOps highlights fact that you should install SQLPackage first if using a #Microsoft hosted agent.
github.com/kevchant/Azu...
github.com/kevchant/Azu...
Published yesterday. Covers CI/CD for Microsoft Fabric Data Warehouses using #AzureDevOps.
Which can now be done gracefully with the new target platform thanks to a new SqlPackage update. With one caveat which I cover in post. #Azure #MicrosoftFabric
www.kevinrchant.com/2023/10/23/c...
Which can now be done gracefully with the new target platform thanks to a new SqlPackage update. With one caveat which I cover in post. #Azure #MicrosoftFabric
www.kevinrchant.com/2023/10/23/c...
CI/CD for Microsoft Fabric Data Warehouses using Azure DevOps - Kevin Chant
In this post I cover CI/CD for Microsoft Fabric Data Warehouses using Azure DevOps. Which can now be done with the new target platform.
www.kevinrchant.com
October 24, 2023 at 10:02 AM
Published yesterday. Covers CI/CD for Microsoft Fabric Data Warehouses using #AzureDevOps.
Which can now be done gracefully with the new target platform thanks to a new SqlPackage update. With one caveat which I cover in post. #Azure #MicrosoftFabric
www.kevinrchant.com/2023/10/23/c...
Which can now be done gracefully with the new target platform thanks to a new SqlPackage update. With one caveat which I cover in post. #Azure #MicrosoftFabric
www.kevinrchant.com/2023/10/23/c...
Covers CI/CD for Microsoft Fabric Data Warehouses using #AzureDevOps.
Which can now be done gracefully with the new target platform thanks to a new SqlPackage update. #Azure #MicrosoftFabric
www.kevinrchant.com/2023/10/23/c...
Which can now be done gracefully with the new target platform thanks to a new SqlPackage update. #Azure #MicrosoftFabric
www.kevinrchant.com/2023/10/23/c...
CI/CD for Microsoft Fabric Data Warehouses using Azure DevOps - Kevin Chant
In this post I cover CI/CD for Microsoft Fabric Data Warehouses using Azure DevOps. Which can now be done with the new target platform.
www.kevinrchant.com
October 23, 2023 at 10:07 AM
Covers CI/CD for Microsoft Fabric Data Warehouses using #AzureDevOps.
Which can now be done gracefully with the new target platform thanks to a new SqlPackage update. #Azure #MicrosoftFabric
www.kevinrchant.com/2023/10/23/c...
Which can now be done gracefully with the new target platform thanks to a new SqlPackage update. #Azure #MicrosoftFabric
www.kevinrchant.com/2023/10/23/c...
[video] SQL DB to MI data mobility with SqlPackage and BACPAC by Rahul Randive: youtu.be/U7qTzwDVHHU
#azuresql #sqlmi #sqldb #bacpac
#azuresql #sqlmi #sqldb #bacpac
SQL DB to MI data mobility with SqlPackage and BACPAC
With SqlPackage you can export your Azure SQL Database to a BACPAC file and then import it into Azure SQL Managed Instance. This can be used to effectively c...
youtu.be
September 21, 2023 at 6:15 PM
[video] SQL DB to MI data mobility with SqlPackage and BACPAC by Rahul Randive: youtu.be/U7qTzwDVHHU
#azuresql #sqlmi #sqldb #bacpac
#azuresql #sqlmi #sqldb #bacpac
Wow. I was creative when I created this dockerfile. It's installing (and ofc downloading first) a million things to finally download and install sqlpackage to deploy a Sql Project into the container image. I mean I knew this, but forgot the circa 1GB download it involves...
August 25, 2023 at 11:13 AM
Wow. I was creative when I created this dockerfile. It's installing (and ofc downloading first) a million things to finally download and install sqlpackage to deploy a Sql Project into the container image. I mean I knew this, but forgot the circa 1GB download it involves...
Reading: #SQLServer Management Studio 18.4 and sqlpackage v18.4 generally available - https://buff.ly/34DYidi #ssms #AzureData
November 23, 2024 at 6:41 PM
Reading: #SQLServer Management Studio 18.4 and sqlpackage v18.4 generally available - https://buff.ly/34DYidi #ssms #AzureData
Both SSMS 18.4 and Sqlpackage 18.4 are now available
https://cloudblogs.microsoft.com/sqlserver/2019/11/05/sql-server-management-studio-18-4-and-sqlpackage-v18-4-generally-available/
https://cloudblogs.microsoft.com/sqlserver/2019/11/05/sql-server-management-studio-18-4-and-sqlpackage-v18-4-generally-available/
SQL Server Management Studio 18.4 and sqlpackage v18.4 ge...
Today we’re announcing the release of SQL Server Manageme...
cloudblogs.microsoft.com
November 14, 2024 at 2:40 AM
Both SSMS 18.4 and Sqlpackage 18.4 are now available
https://cloudblogs.microsoft.com/sqlserver/2019/11/05/sql-server-management-studio-18-4-and-sqlpackage-v18-4-generally-available/
https://cloudblogs.microsoft.com/sqlserver/2019/11/05/sql-server-management-studio-18-4-and-sqlpackage-v18-4-generally-available/