Creating Data for a CML field

The simplest way to populate your database with test data.

Creating Data for a CML field

Postby rockinder » Thu Oct 07, 2010 9:09 pm

I have a table with one column as XMl. this XML contains say student data. Is there a way to create data specific to a XML that I need. Say using a XSD.
the data is like

Want to create say 10k different XMLs in the same structure. is it possible.
Posts: 4
Joined: Mon Aug 31, 2009 7:12 pm

Postby CraigOttley » Fri Dec 17, 2010 12:31 pm

Hi Rockinder,

I've had this problem in the past, If I remember rightly there's no easy way of doing this through SQL Data Generator.

One thing you could try is using the FOR XML clause from flat tables. I think you have to have certain options set on the table and database level for this to work.

This work for me on Adventure works using the Person.Contact table and the AdditionalContactInfo column... (Takes a few seconds for the screen to refresh)

Code: Select all
        NameStyle ,
        Title ,
        FirstName ,
        MiddleName ,
        LastName ,
        Suffix ,
        EmailAddress ,
        EmailPromotion ,
        Phone ,
        PasswordHash ,
FROM    Person.Contact
FOR     XML PATH('Contact') ,

Make sure you have Loop until number... Ticked.

Posts: 13
Joined: Thu Jul 15, 2010 10:50 am
Location: Newport Pagnell

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests