IT Solutions Technology Blog

   Microsoft SQL Server – export XML column rows from SQL table into individual files

It is roughly formatted as such

+————–+——————+
| REFERENCE_ID | REFERENCE_XML |
+————–+——————+
| 1 | <xml>…</xml> |
| 2 | <xml>…</xml> |
| 3 | <xml>…</xml> |
| 4 | <xml>…</xml> |
| … | <xml>…</xml> |
| 70000 | <xml>…</xml> |
+————–+——————+

I would like to loop through every row and bulk export each REFERENCE_XML column and name it as the REFERENCE_ID

My output folder set would look as such

C:\References\1.xml
C:\References\2.xml
C:\References\3.xml
C:\References\4.xml
C:\References\…
C:\References\70000.xml

Microsoft SQL Server Profiler  – is an interface to create and manage traces and analyze and replay trace results events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when diagnosing a problem

Quest Foglight for SQL Server – you can quickly diagnose and resolve SQL Server performance problems and optimize your workloads to prevent future issues. This SQL Server tuning tool includes real-time and historical diagnostics, reporting and more, so you can confidently ensure the health of your entire database environment

Microsoft SQL Server 2019 – Licensing Guide