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

michaelbondar

I need to generate data that has a specific structure in order to be used in subsequent processing.

Jon_Kirkwood

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.