Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16" standalone="yes"?>
- <!--
- SQL Data Generator 3
- SQL Data Generator
- Version:3.0.1.560-->
- <Project version="2" type="SDGProject">
- <DataSource version="3" type="LiveDatabaseSource">
- <ServerName>local</ServerName>
- <DatabaseName>Example</DatabaseName>
- <Username />
- <SavePassword>False</SavePassword>
- <Password />
- <ScriptFolderLocation />
- <MigrationsFolderLocation />
- <IntegratedSecurity>True</IntegratedSecurity>
- </DataSource>
- <Tables type="List<SDGTable>" version="1">
- <value version="1" type="SDGTable">
- <TableType>Generated</TableType>
- <PopulationDetails version="1" type="PopulationDetails">
- <PopulationType>RowCount</PopulationType>
- <RowCount>89832</RowCount>
- <ProportionTableExists>False</ProportionTableExists>
- <Proportion>0</Proportion>
- <TimeToPopulate>0</TimeToPopulate>
- </PopulationDetails>
- <InvalidRowBehaviour>SkipRow</InvalidRowBehaviour>
- <Included>True</Included>
- <Append>False</Append>
- <Name>Account</Name>
- <Schema>salesforce</Schema>
- <Fields type="List<SDGField>" version="1">
- <value version="1" type="SDGField">
- <Name>Id</Name>
- <FieldType>Generated</FieldType>
- <PrimaryKey>False</PrimaryKey>
- <ForeignKey>False</ForeignKey>
- <Unique>False</Unique>
- <AllowsNulls>True</AllowsNulls>
- <SqlType>NVarchar</SqlType>
- <Precision>0</Precision>
- <Scale>0</Scale>
- <DefinedSize>18</DefinedSize>
- <Generator version="1" type="GeneratorDetails">
- <GeneratorTypeName>RedGate.SQLDataGenerator.Generators.Text.StringGenerator</GeneratorTypeName>
- <DisplayName>string (ASCII)</DisplayName>
- <Description>Generates strings</Description>
- <CategoryName>SQL Type</CategoryName>
- <GeneratorProperties type="Dictionary<string, object>" version="1">
- <element>
- <key type="string">Unique</key>
- <value type="string">True</value>
- </element>
- <element>
- <key type="string">MinLength</key>
- <value type="string">0</value>
- </element>
- <element>
- <key type="string">MaxLength</key>
- <value type="string">18</value>
- </element>
- <element>
- <key type="string">Seed</key>
- <value type="string">0</value>
- </element>
- <element>
- <key type="string">NullsAllowed</key>
- <value type="string">False</value>
- </element>
- <element>
- <key type="string">NullProportion</key>
- <value type="string">0.01</value>
- </element>
- </GeneratorProperties>
- </Generator>
- </value>
- </Fields>
- <ForeignKeyProperties type="List<ForeignKeyProperty>" version="1" />
- </value>
- <value version="1" type="SDGTable">
- <TableType>Generated</TableType>
- <PopulationDetails version="1" type="PopulationDetails">
- <PopulationType>RowCount</PopulationType>
- <RowCount>215395</RowCount>
- <ProportionTableExists>False</ProportionTableExists>
- <Proportion>0</Proportion>
- <TimeToPopulate>0</TimeToPopulate>
- </PopulationDetails>
- <InvalidRowBehaviour>SkipRow</InvalidRowBehaviour>
- <Included>True</Included>
- <Append>False</Append>
- <Name>Contact</Name>
- <Schema>salesforce</Schema>
- <Fields type="List<SDGField>" version="1">
- <value version="1" type="SDGField">
- <Name>AccountId</Name>
- <FieldType>Generated</FieldType>
- <PrimaryKey>False</PrimaryKey>
- <ForeignKey>False</ForeignKey>
- <Unique>False</Unique>
- <AllowsNulls>True</AllowsNulls>
- <SqlType>NVarchar</SqlType>
- <Precision>0</Precision>
- <Scale>0</Scale>
- <DefinedSize>18</DefinedSize>
- <Generator version="1" type="GeneratorDetails">
- <GeneratorTypeName>RedGate.SQLDataGenerator.Generators.Others.FKGenerator</GeneratorTypeName>
- <DisplayName>Foreign Key (manual)</DisplayName>
- <Description>References a column from another table</Description>
- <CategoryName>SQL Type</CategoryName>
- <GeneratorProperties type="Dictionary<string, object>" version="1">
- <element>
- <key type="string">ForeignKeyFillMethod</key>
- <value type="string">RepeatForever</value>
- </element>
- <element>
- <key type="string">MinRepeats</key>
- <value type="string">1</value>
- </element>
- <element>
- <key type="string">MaxRepeats</key>
- <value type="string">10</value>
- </element>
- <element>
- <key type="string">Schema</key>
- <value type="string">salesforce</value>
- </element>
- <element>
- <key type="string">Table</key>
- <value type="string">Account</value>
- </element>
- <element>
- <key type="string">Column</key>
- <value type="string">Id</value>
- </element>
- <element>
- <key type="string">ShuffleData</key>
- <value type="string">True</value>
- </element>
- <element>
- <key type="string">Unique</key>
- <value type="string">False</value>
- </element>
- <element>
- <key type="string">Seed</key>
- <value type="string">1024</value>
- </element>
- <element>
- <key type="string">NullsAllowed</key>
- <value type="string">False</value>
- </element>
- <element>
- <key type="string">NullProportion</key>
- <value type="string">0.01</value>
- </element>
- </GeneratorProperties>
- </Generator>
- </value>
- <value version="1" type="SDGField">
- <Name>Email</Name>
- <FieldType>Generated</FieldType>
- <PrimaryKey>False</PrimaryKey>
- <ForeignKey>False</ForeignKey>
- <Unique>False</Unique>
- <AllowsNulls>True</AllowsNulls>
- <SqlType>NVarchar</SqlType>
- <Precision>0</Precision>
- <Scale>0</Scale>
- <DefinedSize>80</DefinedSize>
- <Generator version="1" type="GeneratorDetails">
- <GeneratorTypeName>RedGate.SQLDataGenerator.ExpressionGenerators.Regexp.RegexpGenerator</GeneratorTypeName>
- <DisplayName>Email</DisplayName>
- <Description>Email Addresses (generated)</Description>
- <CategoryName>Personal</CategoryName>
- <GeneratorProperties type="Dictionary<string, object>" version="1">
- <element>
- <key type="string">Expression</key>
- <value type="string">[a-z]{4,8}([0-9]{0,3}|\.[a-z]{4,10})@([a-z]{4,9}\.)?([a-z-]{6})\.(org|com|net)</value>
- </element>
- <element>
- <key type="string">Unique</key>
- <value type="string">False</value>
- </element>
- <element>
- <key type="string">Seed</key>
- <value type="string">1025</value>
- </element>
- <element>
- <key type="string">NullsAllowed</key>
- <value type="string">True</value>
- </element>
- <element>
- <key type="string">NullProportion</key>
- <value type="string">0.01</value>
- </element>
- <element>
- <key type="string">UseSequence</key>
- <value type="string">False</value>
- </element>
- </GeneratorProperties>
- </Generator>
- </value>
- </Fields>
- <ForeignKeyProperties type="List<ForeignKeyProperty>" version="1" />
- </value>
- </Tables>
- <ProjectOptions version="2" type="ProjectOptions">
- <BatchSize>1000</BatchSize>
- <FireInsertTriggers>True</FireInsertTriggers>
- <FireDeleteTriggers>False</FireDeleteTriggers>
- <CheckConstraints>True</CheckConstraints>
- <ShuffleBlockSize>1000</ShuffleBlockSize>
- </ProjectOptions>
- <PreScripts type="SQLScripts" version="1" />
- <PostScripts type="SQLScripts" version="1" />
- <IsRefresh>False</IsRefresh>
- </Project>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement