I am working on a .net framework-based windows application and I want to export data from a database and then import it to the other database with the same schema.
Asked
Active
Viewed 103 times
0
-
I don't believe that's possible: the software that creates the `*.bacpac` exists within SSMS, not SQL Server. – Dai Oct 07 '22 at 16:20
-
2Ah, [the docs say you can use `Microsoft.SqlServer.Management.Dac.DacStore.Export()` to generate a `*.bacpac` from C#/.NET code](https://learn.microsoft.com/en-us/sql/relational-databases/data-tier-applications/export-a-data-tier-application#NetApp) (just not T-SQL). – Dai Oct 07 '22 at 16:21