FolderCopy

Copies a folder and its content from source to destination

Stored Procedure
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

EXEC SQLHTTP.net.FolderCopy @SourceFolderPath, @DestinationFolderPath, @Recursive

Arguments:

Name	Type	Description
@SourceFolderPath	varchar(MAX)	Full path to the existing source folder
@DestinationFilePath	varchar(MAX)	Full path to a non-existing destination folder
@Recursive	bit	1 = All sub-directories in @SourceFolderPath will be copied as well 0 = Existing sub-directories in @SourceFolderPath will NOT be copied.



Remarks:

Accessing the file system will be performed in the context of the SQL Server instance process. You can set SQL Server to run using a specific network account, or a Local System Account.



Sample Usage:


DECLARE @SourceFolderPath varchar(MAX)
DECLARE @DestinationFolderPath varchar(MAX)
DECLARE @Recursive bit

SET @SourceFolderPath = 'C:\ThisFolderExists'
SET @DestinationFolderPath = 'C:\ThisFolderWillSoonExist'

--If you'd like sub-folders to be copied as well, set this value to 1.
SET @Recursive = 0

EXEC SQLHTTP.net.FolderCopy @SourceFolderPath, @DestinationFolderPath, @Recursive

DECLARE @SourceFolderPath varchar(MAX)

DECLARE @DestinationFolderPath varchar(MAX)

DECLARE @Recursive bit

SET @SourceFolderPath = 'C:\ThisFolderExists'

SET @DestinationFolderPath = 'C:\ThisFolderWillSoonExist'

--If you'd like sub-folders to be copied as well, set this value to 1.

SET @Recursive = 0

EXEC SQLHTTP.net.FolderCopy @SourceFolderPath, @DestinationFolderPath, @Recursive

Command(s) completed successfully.



FolderCopy

Featured API Wrapper Code / SQL Server