Use SQL Data Generator using SQL statement

Can you use SQL Data Generator by writing a SQL statement?  If so, how?

Answers

  • Eddie DEddie D Posts: 1,733 Rose Gold 5
    Hi,
    Yes you can use a SQL Statement.

    Select the column you wish to generate the SQL Statement upon.  The column generation settings will appear.  Select the Generator drop down and change from the default generator selected to SQL Statement listed under the Generic heading, as per the screen shot below.



    Next enter the SQL Source connection details and finally type in the SQL statement to select a column with a matching data type.


    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.