title: How to insert Huge dummy data to Sql server
body: <p>Currently development team is done their application, and as a tester needs to insert 1000000 records into the 20 tables, for performance testing.</p>
  
  <p>I gone through the tables and there is relationship between all the tables actually.</p>
  
  <p>To insert that much dummy data into the tables, I need to understand the application completely in very short span so that I don't have the dummy data also by this time.</p>
  
  <p>In <code>SQL server</code> is there any way to insert this much data insertion possibility.</p>
  
  <p>please share the approaches.</p>
  
  <ol>
  <li>Currently I am planning with the possibilities to create dummy data in <strong>excel</strong>, but here I am not sure the relationships between the tables.</li>
  <li>Found in Google that <strong>SQL profiler</strong> will provide the order of execution, but waiting for the access to analyze this.</li>
  <li>One more thing I found in Google is <strong>red-gate</strong> tool can be used.</li>
  </ol>
  
  <p>Is there any script or any other solution to perform this tasks in simple way.</p>
  
  <p>I am very sorry if this is a common question, I am working first time in SQL real time scenario. but I have the knowledge on SQL.</p>