Red Gate forums :: View topic - Foreign Key Generator - request
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

Foreign Key Generator - request

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
HugoKornelis



Joined: 25 Mar 2009
Posts: 5

PostPosted: Fri Aug 02, 2013 10:42 pm    Post subject: Foreign Key Generator - request Reply with quote

Hi all,

I'm trying to use SQL Data Generator (version 2.0.3.1) to generate extra data for the FactResellerSales table in the AdventureWorksDW2012 sample database. But in order to make it match the pattern of the rest, I find that some features are missing from Data Generator.

One of them is for generating the columns OrderDateKey, ShipDateKey, and DueDateKey. These are foreign keys into the DimDate table, but they are always equal to their datetime counterparts (OrderDate, ShipDate, DueDate) - except the foreign keys are represented as an integer in yyyymmdd format.

These values are very easy to compute from the OrderDate, ShipDate, and DueDate columns. But there is no option for this in Data Generator. In fact, there is no choice for the generation method at all for foreign key
columns - even if I were able to write Python, I'd still be unable to use that skill for these columns.

I first thought this is a very unusual request and was hesitant to make it, but then I realized that in a data warehouse, this is not an uncommon design. So everyone who needs to generate test data for a DW would run into this problem.

Maybe RedGate can consider adding a feature for this?

Thanks in advance! Smile
_________________
--
Hugo Kornelis
(SQL Server MVP and Friend of Red Gate)
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group