Skip a field
wwilkins
Posts: 5
I need to keep my primary key. How can I not have it "Server assigned" ?
Comments
http://documentation.red-gate.com/displ ... ata+source
That way, you can use some existing data in the generated data because you have created a copy of the schema and have configured SQL query generators to pull the original data across.
We do not want to change the PK. on multiple tables in the DB. Am I missing something in the directions?
SQL Data Generator has a hard-coded "server assigned" generator for IDENTITY columns that you cannot change because identity columns have to conform to the constraint on the server anyway (seed value, increment, and current value). The topic was primarily about that, so I was going to raise a feature request to allow "at your own risk" changes there if there is a need for it.