title: Is there a way to "export" an entire SQL Server database (schema and data) to text?
body: <p>On a per-object basis, SQL Server Management Studio has the option to script the object to clipboard, file, etc.  Is there a way (at the database level) to do a "1-click" export of ddl AND data to a text file?  Ideally I'd like to select a database and create a big text file containing the ddl for all objects plus the data in all tables.  I see the data export wizard (dts/ssis) as a very different thing which really isn't what I'm looking for.</p>
  
  <p>Is this capability available either in SQL Server Management Studio or in the Visual Studio Database Edition?</p>