title: Generating Schema and Data for SQL Server Express Edition with Advanced Services
body: <p>I have Microsoft SQL Server Express Edition with Advanced Services for 2008.</p>
  
  <p>I only see script option for the database and not for Schema and Data.</p>
  
  <p>Is this feature available in SQL Server Express Edition?</p>
  
  <p>I came across a resource which mentioned.</p>
  
  <p>From within SQL Management Studio Express I can use
  Generate and Publish Script and click on advanced and get Advanced Scriptiong options and specify Schema and metadata. </p>
  
  <p>I don't see this option in my Express Edition is this option available only in SQL Server 2012?</p>
  
  <p>Please advice.</p>