search

wise-coders / dbschema

DbSchema Database Designer
https://dbschema.com
67 stars 3 forks source link

load_values_from_pk in Data Generator #98

Closed NeilN1 closed 1 year ago

NeilN1 commented 1 year ago

How do I use load_values_from_pk as a pattern in the data generator? I've confirmed the FK exists and have the following but it's obviously not picking up values from the PK table (SQL Server, latest version of DbSchema).

image

NeilN1 commented 1 year ago

Ok figured out the sample is not a live preview. One small issue: Generating data directly into the db works fine but generating SQL scripts generates true/false for bit fields which SQL Server doesn't like:

Invalid column name 'false'.

wise-coders commented 1 year ago

Issue will be solved right this week. The beta update from next week will get the fixes for both issues ( fk generator and bit fields ).