DacFx
DacFx copied to clipboard
Unable to specify TempDirectoryForTableData for Import action
TempDirectoryForTableData is available for Export action, and makes it possible to have a dedicated Folder/Drive to hold all the data, and is especially useful for very large databases, and not run out of space on the OS drive.
The same option should be available for Importing databases, can you consider this as a candidate to add the option?
@dzsquared FYI
Hi, that's a good point and we can review this to add as an option for import. In the meantime, the workaround would be to set the environment variable 'TMP' for sqlpackage process, or the process that running DacFx operations to a folder other than user temp.
Because this is not part of the documentation, what would be the default folders when using a different OS than Windows? The users home folder, the sqlpackage folder?
Being added to documentation with https://github.com/MicrosoftDocs/sql-docs-pr/pull/24109
Now documented https://docs.microsoft.com/sql/tools/sqlpackage/sqlpackage#temporary-files