title: How to get script of SQL Server data?
body: <p>I'm looking for a way to do something analogous to the MySQL dump from SQL Server. I need to be able to pick the tables and export the schema and the data (or I can export the schema via SQL Server Management Studio and export the data separately somehow).</p>
  
  <p>I need this data to be able to turn around and go back into SQL Server so it needs to maintain GUIDs/uniqueidentifiers and other column types.</p>
  
  <p>Does anyone know of a good tool for this?</p>