Activity overview
Latest activity by sillimans
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...
Source Controlling Data removes DROP CONSTRAINT
Hi,
To save the trouble of everyone in my department manually clicking on which tables to source control data, I've been saving insert scripts toTFS's data folder, so when users click on "get lates...
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 ...
Redgate tool that populates sourced controlled tables?
I source controlled a production database to my local server. I have all the objects, but would like data to test. I know there is Data Compare, but populating one table, never mind a database, w...
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...
Does Data Compare recognize foreign keys in selected rows?
I source controlled a database to my local server, so what I have are empty tables. I need a small data set for testing, and I don't want to wait for data compare to fill the empty table with the ...