With version 18.7 and above of SqlPackage, Azure Synapse Analytics gains improved portability through the Parquet flat file format. Through additional command line properties on the Extract operation (see documentation) data is written to flat files in Azure Blob Storage while the schema is stored in a Dacpac file. ![]() Flat files storing data can be published to a database along with a Dacpac through the Publish operation with similar command line properties. In some SqlPackage import scenarios indexes have a large impact on the performance, whether it is an index assisting with data insertion speed or rebuilding indexes hampering other operations.īoth Extract and Publish operations have large performance improvements when writing to Azure Blob Storage for large database sizes. ![]() To allow further tuning SqlPackage’s behavior in these cases, the command line properties “RebuildIndexesOfflineForDataPhase” and “DisableIndexesForDataPhase” were added to the Import action in SqlPackage 18.7.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |