What are the challenges you face when working across database platforms? Take the survey
Options

Is there any way to build intelligence into how data is assigned in columns ?

I have for example, tables that are many to one configuration.  I would like the name columns, etc. to be cognizant to the primary keys and only change when the keys do.  Also, I was wondering how to make information aware of, for example I have First name, Last Name, Middle Initial, and a Full Name column.  How do i make the columns all work together when i need to change the names, etc. instead of having different names that don't match.
Tagged:

Answers

  • Options

    Hi @Dale_MFM,

    Thanks for reaching out on the Redgate forums.


    There are some methods to utilize data in other columns when running Data Generator.

    • Depending on your requirements and skill levels you can create new generators using .NET

    https://documentation.red-gate.com/sdg4/using-generators/creating-new-generators

    • For a simple use case though it may be useful to write a python script which can be run on a column.

    https://documentation.red-gate.com/sdg4/using-generators/example-python-scripts


    I've spun up a quick sample below where I have a table with fields:

    First_Name, Last_Name & Full_Name


    First_Name & Last_Name are using our standard generators

    Then for Full_Name I wrote a simple script that loops through each record and creates a concatenation of records.

    When a field change occurs the python script updates the record to match

    This could be modified for your own requirements to add in extra fields or manipulate them further



    Hope this assists with building some finer data handling intelligence into your Data Generator usage.

    Jon Kirkwood | Technical Support Engineer | Redgate Software
Sign In or Register to comment.