Activity overview
Latest activity by rchutch
As an update, we went back and forth many times and - there is no way to do this.
The closest thing you can do is to delete, then recreate. This is OK if your data is simple, but does not work if:
You have autonumber primary key values that are referenced in other tables. When you re-create your data, if there were any deleted records in the original sample data, the new data will not have those "missing ID values" and you will end up with mismatched records
If your records have foreign keys, delete, then recreate will not work - consider cascading deletes, etc.
I asked for Red-Gate to consider this as a feature request. Who knows?
I am now looking for another tool to help with this very large and very real problem. Are there others who have the same problem? Perhaps if so, they wouldn't think it is just me with this issue.
Thanks,
Rob / comments
As an update, we went back and forth many times and - there is no way to do this.
The closest thing you can do is to delete, then recreate. This is OK if your data is simple, but does not work if:...
Change one column in a table
Hi,
So, feature request. We have lots and lots of student-related test data that has "grown old". We would like to update a few fields, like change student grade levels or birth dates so that the...
Creating multiple, small scripts instead of one huge one
I know that you can ask the Data Compare Tool to create transactions of a certain size and that's going a little bit in the right direction.
We need to be able to use the output of the Data Compare...