Comments
Sort by recent activity
Mine seems to be the opposite problem of yours. . .I want to add constraints with nocheck. There are over 1000 tables in our database, and it's impossible to source control all data. Sometimes it's necessary to grab data for one table I'm working on without also source controlling parent table. However, I can't because the "ADD CONSTRAINT WITH NOCHECK" is removed from my data files in TFS. / comments
Mine seems to be the opposite problem of yours. . .I want to add constraints with nocheck. There are over 1000 tables in our database, and it's impossible to source control all data. Sometimes it...
My identity columns are server assigned, and I can't see the value until after the insert, and after reseeding. Does DG have an option to not treat identities as a server assigned value?
Also, my identity column starts at 1, but because rows were deleted, the min identity value is ~20k. I'm not sure if in your testing you started identity at 1,000 or your min identity value was 1,000. / comments
My identity columns are server assigned, and I can't see the value until after the insert, and after reseeding. Does DG have an option to not treat identities as a server assigned value?
Also, my ...
Thanks for the reply. In my brief experience with Data Generator, I noticed that the identity columns were re seeded. I have some tables with identity columns that start in the thousands. I would prefer to retain those identity values to keep it as close to production as possible - is this possible? / comments
Thanks for the reply. In my brief experience with Data Generator, I noticed that the identity columns were re seeded. I have some tables with identity columns that start in the thousands. I woul...