Activity overview
Latest activity by icecurtain
Still happening in latest version
If found that the role has a impact on this using db_owner worked for me. / comments
Still happening in latest version
If found that the role has a impact on this using db_owner worked for me.
I found and easier fix open,don't open by program but by SSMS select source and target the launch data compare it seems to create the project from there OK.
This caused a few hours of frustration. / comments
I found and easier fix open,don't open by program but by SSMS select source and target the launch data compare it seems to create the project from there OK.
This caused a few hours of frustration.
(AB|B|BA|BB|BD|BH|BL|BN|BR|BS|BT|CA|CB|CF|CH|CM|CO|CR|CT|CV|CW|DA|DE|DG|DH|DL|DN|DT|DY|E|EC|EH|EN|EX|FK|FY|G|GL|GU|H|HG|HP|HR|HS|HU|HX|IG|IM|IP|IV|KA|KT|KW|KY|L|LA|LD|LE|LL|LN|LS|LU|M|ME|MK|MK|N|NE|NG|NN|NP|NR|NW|OL|OX|PA|PE|PH|PL|PO|PR|RG|RH|RM|S|SA|SE|SG|SK|SL|SM|SN|SO|SP|SR|SS|ST|SW|SY|TA|TD|TF|TN|TQ|TR|TS|TW|UB|W|WA|WC|WD|WF|WN|WR|WS|WV|Y|ZE)([1-9]|[1-9][0-9]) [1-9](A|B|D|E|F|G|H|J|N|P|Q|R|S|T|U|V|W|X|Y|Z){2} / comments
(AB|B|BA|BB|BD|BH|BL|BN|BR|BS|BT|CA|CB|CF|CH|CM|CO|CR|CT|CV|CW|DA|DE|DG|DH|DL|DN|DT|DY|E|EC|EH|EN|EX|FK|FY|G|GL|GU|H|HG|HP|HR|HS|HU|HX|IG|IM|IP|IV|KA|KT|KW|KY|L|LA|LD|LE|LL|LN|LS|LU|M|ME|MK|MK|N|NE...
UK postcode unit are restricted
The final two letters, the UK postcode unit are restricted to the set ABDEFGHJLNPQRSTUWXYZ (which excludes the six letters CIKMOV)
The code on the download still has these in and is causing validat...
<?xml version="1.0" encoding="iso-8859-1"?>
<generators>
<generator
type = "RedGate.SQLDataGenerator.Generators.Number.Int64Generator"
name = "BigInt"
description = "Generates BigInts"
category = "Generic">
<property name = "MinValue">1</property>
<property name = "MaxValue">999999</property>
<property name = "UseSequence">False</property>
<property name = "Unique">True</property>
<property name = "ValidateIncrement">1</property>
<property name = "NullsAllowed">False</property>
<matches field = "." score = "999"/>
<type type = "bigint"/> <type type = "Int64"/>
</generator>
</generators>
works but thanks for the right direction
path = C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config / comments
<?xml version="1.0" encoding="iso-8859-1"?>
<generators>
<generator
type = "RedGate.SQLDataGenerator.Generators.Number.Int64Generator"
name = "BigInt"
de...
globally set bigint and datetime
Hi,
How can I globally set that for all Bigint and datetime data types, the default for all tables the project should be 1 thru 999,999 unique with no null ?
Date time 01-01-1901 00:00 - 01-01-1901...
Found the answer, it is to use between 10 and 10 not 1 and 10 sorted, a night sleep clears the mind. / comments
Found the answer, it is to use between 10 and 10 not 1 and 10 sorted, a night sleep clears the mind.
Two tables one header, one lines need lines refer to header
Hi I'm fairly new to Data generator, so if this is a silly easy question - sorry for that, but I can't find an answer on my own.
(aim create 1,000 header rows, 10,000 line rows)
Two tables one head...
Thanks for the reply. I would definitely like it as a new feature! / comments
Thanks for the reply. I would definitely like it as a new feature!
can SQL DG calculate a column value?
Just evaluting SQL data generator and if anyone can tell me if this is possible.
Circa 10,000,000 row need to be created.
COL A (Qty) = Random number 1-50
COL B (Qty_Delivered) must be lower than C...