DB Dude: Import data to sandbox from production DB on post deployment

One of our customers implemented DB Dude as part of the development cycle.

The customer had the following requirements from the data generation:

1. The data must be closer as possible to the production environment data (remote machine).
2. The data generation has to be fast - generate only new data when deployment occur.
   

The Data generation plan which supplied with the Db Dude is a great utility but the customer has ~1000 tables , ~10K columns and to create data generation plan that answers these requirements is a very complicated thing.

We developed a utility (win form) that generates an import script from one database to another. The utility displays to the user the available databases on the source server; the user selects the required tables to be included in the import script; the user select the target database.

The utility generates the import script based on the 'Open RowSet' method and selects only the new/updated data that should be imported to the sandbox database.

This generated script is placed at the post deployment scripts as the last executable script.