Data generator
Redgate does a data generator that is quite useful. It looks at the schema for the tables and generates randomized (according to rules that you can select) data to fill them. It is quite useful when you need to say generate 100,000 rows for testing.
Data Generator is available in dbForge Studio for SQL Server, v4.5. Feel free to leave a feedback.
-
Mikael Bang Korsgaard commented
Great feature! But it only ssems to be able to generate new rows ... would be great if it could overwrite existing rows - e.g. to anonymize certain rows!
-
Steve Howe commented
I agree this would be a VERY nice enhancement. The above tool allows for truncating the tables for a quick delete of data and allows userst to use a BCP type function to add (sync) large tables which we need to do frequently on my team.