Custom SQL Statement Generator

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Custom SQL Statement Generator

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

Hope this helps anyone who uses the Generic SQL Statement a lot. It's saving me huge amounts of time when most things are stored in a Database!

Code: Select all
<generators>
   <generator type="RedGate.SQLDataGenerator.Generators.SQL.SQLColumnGenerator"
                   name="Male First Names"
                   description="Adam, Brian, Chris etc..."
                   category="Data Dictionary">
      <property name="ServerName">MSSQLSERVER</property>
      <property name="DatabaseName">AdventureWorks</property>
      <property name="SQLQuery">SELECT  FirstName AS [Male First Names]
FROM    Person.Contact
WHERE   Title = 'Mr.'
GROUP BY FirstName</property>
      <property name="LoopQuery">True</property>
      <matches field="Forename*" score="80"/>
      <type type="string"/>
   </generator>
</generators>
CraigOttley
 
Posts: 13
Joined: Thu Jul 15, 2010 11:50 am
Location: Newport Pagnell

Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests