DacFx icon indicating copy to clipboard operation
DacFx copied to clipboard

Unable to specify TempDirectoryForTableData for Import action

Open ataidecarlos opened this issue 3 years ago • 3 comments

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?

ataidecarlos avatar Mar 18 '21 23:03 ataidecarlos

@dzsquared FYI

udeeshagautam avatar Mar 18 '21 23:03 udeeshagautam

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.

llali avatar Mar 23 '21 00:03 llali

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?

ataidecarlos avatar Apr 27 '21 21:04 ataidecarlos

Being added to documentation with https://github.com/MicrosoftDocs/sql-docs-pr/pull/24109

dzsquared avatar Sep 07 '22 20:09 dzsquared

Now documented https://docs.microsoft.com/sql/tools/sqlpackage/sqlpackage#temporary-files

dzsquared avatar Sep 08 '22 13:09 dzsquared