{"id":14144,"date":"2020-05-11T15:28:52","date_gmt":"2020-05-11T13:28:52","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/"},"modified":"2020-05-11T15:28:52","modified_gmt":"2020-05-11T13:28:52","slug":"sql-server-2019-copy-files-through-sql-server","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/","title":{"rendered":"SQL Server 2019: Copy files through SQL Server"},"content":{"rendered":"<p>Three new interesting extended stored procedures comes with SQL Server 2019.<br \/>\nI was very interested to discover these new store procedures:<\/p>\n<ul>\n<li><strong>Sys.xp_copy_file<\/strong> is to copy a specific files from a folder to another\n<ul>\n<li>Syntax: exec master.sys.xp_copy_file &#8216;source folder+file&#8217;, &#8216;destination folder+file&#8217;<\/li>\n<li>Example:\n<pre class=\"brush: sql; gutter: true; first-line: 1\">exec master.sys.xp_copy_file 'C:\\Temp\\Sources\\File1.txt', 'C:\\Temp\\Destinations\\File1.txt'<\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Before the command:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-39629\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file01.png\" alt=\"\" width=\"300\" height=\"91\" \/><\/a><\/p>\n<p>After the command:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-39630\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file02.png\" alt=\"\" width=\"300\" height=\"171\" \/><\/a><br \/>\nAs you can see in my test, you will have these 2 information where indicate the sucess of the query:<br \/>\n<em>Commands completed successfully.<\/em><br \/>\n<em>Time: 0.315s<\/em><\/p>\n<ul>\n<li><strong>Sys.xp_copy_files<\/strong> is to copy multiple files though the wildcard Character from a folder to another\n<ul>\n<li>Syntax: exec master.sys.xp_copy_files &#8216;source folder+files&#8217;, &#8216;destination folder&#8217;<\/li>\n<li>Example:\n<pre class=\"brush: sql; gutter: true; first-line: 1\">exec master.sys.xp_copy_files 'C:\\Temp\\Sources\\File*.txt', 'c:\\Temp\\Destinations\\'<\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Before the command:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-39631\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file03.png\" alt=\"\" width=\"300\" height=\"194\" \/><\/a><\/p>\n<p>After the command:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file04.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-39633\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file04.jpg\" alt=\"\" width=\"300\" height=\"171\" \/><\/a><\/p>\n<ul>\n<li><strong>Sys.xp_delete_files<\/strong> is to delete a specific file or multiple files though the wildcard Character in a folder\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>Syntax: exec master.sys.xp_delete_files &#8216;source folder+files&#8217;<\/li>\n<li>Example:\n<pre class=\"brush: sql; gutter: true; first-line: 1\">exec master.sys.xp_delete_files 'c:\\Temp\\Destinations\\File*.txt'<\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Before the command:<\/li>\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file05.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-39634\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file05.png\" alt=\"\" width=\"300\" height=\"157\" \/><\/a>After the command:<\/li>\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file06.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-39635\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file06.jpg\" alt=\"\" width=\"300\" height=\"171\" \/><\/a><\/li>\n<\/ul>\n<p>I go a little forward to see how it\u2019s reacted if the file already exists or when we update the source<br \/>\nI copy the first time the file &#8216;c:\\ Temp\\Sources\\file1.txt\u2019 to &#8216;c:\\ Temp\\Destinations\\file1.txt&#8217;<br \/>\nI have one line \u201cfirst Line\u201d<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file07.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-39636\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file07.png\" alt=\"\" width=\"300\" height=\"174\" \/><\/a><br \/>\nI had to the source a second Line \u201csecond line\u201d<br \/>\nI copy again the file and result\u2026<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file08.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-39637\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file08.png\" alt=\"\" width=\"300\" height=\"166\" \/><\/a><br \/>\nAs you can see, the second line is in the destination.<br \/>\nWithout warning or question, the file is overwriting.<\/p>\n<p>The funny part is when you create a file manually (file6.txt) and want to delete it through SQL Server, it\u2019s not possible.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file09.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-39640\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file09.jpg\" alt=\"\" width=\"300\" height=\"171\" \/><\/a><br \/>\nOnly the file, where SQL Server account is the owner, will be deleted&#8230;<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file10.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-39641\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file10.jpg\" alt=\"\" width=\"300\" height=\"171\" \/><\/a><\/p>\n<p>Before SQL Server 2019, to do these operations, we use xp_cmdshell. Now with this new version, we can do easily copy operation or delete operations for files in a folder.<br \/>\nIt\u2019s very good and useful! A customer already asks me to implement it&#8230;<br \/>\nSee you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Three new interesting extended stored procedures comes with SQL Server 2019. I was very interested to discover these new store procedures: Sys.xp_copy_file is to copy a specific files from a folder to another Syntax: exec master.sys.xp_copy_file &#8216;source folder+file&#8217;, &#8216;destination folder+file&#8217; Example: exec master.sys.xp_copy_file &#8216;C:\\Temp\\Sources\\File1.txt&#8217;, &#8216;C:\\Temp\\Destinations\\File1.txt&#8217; Before the command: After the command: As you can see [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":14145,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[],"type_dbi":[],"class_list":["post-14144","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2019: Copy files through SQL Server - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2019: Copy files through SQL Server\" \/>\n<meta property=\"og:description\" content=\"Three new interesting extended stored procedures comes with SQL Server 2019. I was very interested to discover these new store procedures: Sys.xp_copy_file is to copy a specific files from a folder to another Syntax: exec master.sys.xp_copy_file &#8216;source folder+file&#8217;, &#8216;destination folder+file&#8217; Example: exec master.sys.xp_copy_file &#039;C:TempSourcesFile1.txt&#039;, &#039;C:TempDestinationsFile1.txt&#039; Before the command: After the command: As you can see [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-11T13:28:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file01.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2048\" \/>\n\t<meta property=\"og:image:height\" content=\"624\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2019: Copy files through SQL Server\",\"datePublished\":\"2020-05-11T13:28:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/\"},\"wordCount\":325,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Xp_copy_file01.png\",\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/\",\"name\":\"SQL Server 2019: Copy files through SQL Server - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Xp_copy_file01.png\",\"datePublished\":\"2020-05-11T13:28:52+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Xp_copy_file01.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Xp_copy_file01.png\",\"width\":2048,\"height\":624},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2019-copy-files-through-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2019: Copy files through SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2019: Copy files through SQL Server - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2019: Copy files through SQL Server","og_description":"Three new interesting extended stored procedures comes with SQL Server 2019. I was very interested to discover these new store procedures: Sys.xp_copy_file is to copy a specific files from a folder to another Syntax: exec master.sys.xp_copy_file &#8216;source folder+file&#8217;, &#8216;destination folder+file&#8217; Example: exec master.sys.xp_copy_file 'C:TempSourcesFile1.txt', 'C:TempDestinationsFile1.txt' Before the command: After the command: As you can see [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/","og_site_name":"dbi Blog","article_published_time":"2020-05-11T13:28:52+00:00","og_image":[{"width":2048,"height":624,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file01.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2019: Copy files through SQL Server","datePublished":"2020-05-11T13:28:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/"},"wordCount":325,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file01.png","articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/","name":"SQL Server 2019: Copy files through SQL Server - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file01.png","datePublished":"2020-05-11T13:28:52+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file01.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Xp_copy_file01.png","width":2048,"height":624},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2019-copy-files-through-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2019: Copy files through SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14144"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14144\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14145"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14144"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}