Redgate tool that populates sourced controlled tables?

sillimans

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, with a million rows, takes hours. I've also used Data Generator to generate data from an existing source, but I noticed that it reseeds the identity columns, which I would like to retain.

So, what is the best Redgate tool that is used to populate an empty database after source controlling all objects?

Evan Moss

Hello,

For anyone looking at this post, the discussion is continued here: http://www.red-gate.com/MessageBoard/vi ... hp?t=21865

Thanks,
Evan