Is it possible to generate XML data that has specific structure (element names, nesting, etc)?

• 

  Hi @michaelbondar

  
  

   Thank you for reaching out on the Redgate forums regarding your SQL Data Generator question.

  
  

  There is some information on generating XML available through the help site > Using Generators

  https://documentation.red-gate.com/sdg/using-generators

   

  Generating XML

  There are a number of ways in which you can generate XML values:

  • use the XML or Python script generator to generate XML strings
  • use the Regex generator and write a regular expression that obeys the XML definition
  • use the File Import generator to import XML files
  • use the SQL Statement generator to retrieve values from another database that contains schema-validated XML

   

  There are possibly multiple ways to achieve your goal, and can often depend on the volume and complexity of the XML you are attempting to generate.
  

  Hopefully one of these generators may help with your requirements.

   

  If you are having any specific concerns with your data generation, please feel free to share, and we may be able to assist further.

  Jon_Kirkwood September 27, 2023 05:32

  - 0 +

Add comment

Please sign in to leave a comment.