How can we help you today? How can we help you today?

Generating data that respects logical partitions

I have a single physical database whose tables are logically partitioned by a PartitionId (a GUID). As an example, let's say I have two tables:

Order
===
Id
PartitionId
ContactId

Contact
===
Id
PartitionId

When using SQL Data Generator to generate data and fill Order.ContactId, is it possible to tell it to only select Contacts whose PartitionId match the Order.PartitionId?

Thank you,

Jon
jonsagara
0

Comments

1 comment

Sort by
  • Jessica R
    Hi Jon,

    Thanks for your post!

    You can use a SQL Statement generator to generate the data for Contact's PartitionId column.

    You'll need to set the generator to connect to the same database and then the statement can be: SELECT PartitionID FROM Order

    I hope that helps!
    Jessica R
    0

Add comment

Please sign in to leave a comment.