title: Copy datarow from relational database along with its relational data
body: <p>Using SQL Server 2005\2008</p>
  
  <p>Is there a way to copy a particular data row from one relation database to another similar database, along with its relational data? In a sense that all the other data (FKs) from this database which will need to be there for this particular data row to exist in destination database should also be copied.</p>
  
  <p>I basically need to copy a particular scenario from the production box to test box, without copying the entire table \databases over to test systems. </p>
  
  <p>I can definitely find all the Fk from this table and copy the data manually but that is too time consuming when the base tables keeps changing.</p>
  
  <p>Any tool\ generic queries that can help me move a data scenario from one relational database to other. </p>