Comments
Sort by recent activity
Thanks Linda.
For everyone else this code works for me [image] ) <generators>
<generator type="RedGate.SQLDataGenerator.Generators.List.WeightedListGenerator"
name="Yes|No"
description="95 | 5%..."
category="Weighted Lists">
<property name="Seed">0</property>
<property name="NullsAllowed">False</property>
<property name="NullProportion">0.01</property>
<property name="ListItems">
<WeightedListOfItems type="WeightedListOfItems" version="1">
<value version="1" type="WeightedListItem">
<Name>Yes</Name>
<Weight>95</Weight>
</value>
<value version="1" type="WeightedListItem">
<Name>No</Name>
<Weight>5</Weight>
</value>
</WeightedListOfItems>
</property>
<matches field="*Option*" score="70"/>
<type type="Object"/>
<type sqlType="Char"/>
<type sqlType="Varchar"/>
<type sqlType="NChar"/>
<type sqlType="NVarchar"/>
<type sqlType="NText"/>
</generator>
</generators>
/ comments
Thanks Linda.
For everyone else this code works for me )<generators>
<generator type="RedGate.SQLDataGenerator.Generators.List.WeightedListGenerator"
name="Yes|No"
...
Have you had a look at Ben Halls post about embedding IronRuby or another language? http://www.simple-talk.com/content/article.aspx?article=697 / comments
Have you had a look at Ben Halls post about embedding IronRuby or another language?http://www.simple-talk.com/content/article.aspx?article=697
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) SELECT TOP 1
NameStyle ,
Title ,
FirstName ,
MiddleName ,
LastName ,
Suffix ,
EmailAddress ,
EmailPromotion ,
Phone ,
PasswordHash ,
PasswordSalt
FROM Person.Contact
ORDER BY NEWID()
FOR XML PATH('Contact') ,
ROOT('Person')
Make sure you have Loop until number... Ticked.
HTH / comments
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 ta...
I've come up with a work around for this. I've created a user for SQL Doc and revoked all privileges except for Tables and Views [image] . SQL Doc can't generate documentation for what is hasn't got access to.
Simple Example USE master
GO
GRANT VIEW ANY DEFINITION TO SQLDoc
GO
REVOKE VIEW ANY DEFINITION FROM SQLDoc
GO
[/code] / comments
I've come up with a work around for this. I've created a user for SQL Doc and revoked all privileges except for Tables and Views . SQL Doc can't generate documentation for what is hasn't got acce...
Look's like i've managed to solve the problem. I had to grant full access to the folder
C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config
for the user that is running the generator.
The 'error/warning' message does not appear anymore.
Additional Notes for everyone else:
I tried setting the Privilege Level "Run this program as an administrator" for all users for "SQLDataGenerator.exe" this quickly prompted Windows 7 to ask "Do you want the following program from an unknown publisher to make changes to this computer" which didn't work for me. / comments
Look's like i've managed to solve the problem. I had to grant full access to the folder
C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config
for the user that is running the generator.
Th...
Hi Anu,
That doesn't solve my problem as i'm not running the data generator via the UI.
If you place this in a .bat file you'll most likely see the error.
cd C:\Program Files (x86)\Red Gate\SQL Data Generator 1SQLDataGenerator /pr:"C:\ProjectName.sqlgen" /v
/ comments
Hi Anu,
That doesn't solve my problem as i'm not running the data generator via the UI.
If you place this in a .bat file you'll most likely see the error.
cd C:\Program Files (x86)\Red Gate\SQL Da...
Why couldn't you use a Regular Expression?
IE
99(8|9) \d{3} \d{4} / comments
Why couldn't you use a Regular Expression?
IE
99(8|9) \d{3} \d{4}