I'm looking for an enterprise tool / product - paid or free that is designed to handle selective backup / restore of massive MS SQL Server databases.
A simple usage scenario would be - from our prod database, to daily have a dev database restored with only a subset of data from Prod. This needs to be configured on a table by table basis. So certain tables can restore with more historic data than others, while some will just be completely excluded.
I'll be clear - what I don't want is a tool that does a complete backup, and then follows this up with truncate or delete commands.
I'm ideally looking for something defacto and industry standard tool, something that we can implement fairly easily and rollout across the board.
EDIT: I'm also thinking of just writing a custom tool which would use a series of inserts to get the job done, but I don't think this is the best / quickest way to do this, because performance is a major deciding factor.
Thanks in advance.