Hi everyone,

We have a big database with ~ 20 related tables inside. There are no triggers or rules, as I know. One of the tables is called Jobs and has JobID (I), JobType, LastRunDate, etc. fields. This table has several dependent tables, such as JobSteps, for example. I want to have a light version of that database with two most recent jobs per each job type. How can I automate the process of creating such "light" version of a database? And I am also curious, if a generic tool, which allows to easily do such task, already exists.

Thanks a lot in advance.