title: Want to create a script to export Data and tables and views to a sql script
body: <p>Want to create a script to export Data and tables and views to a sql script.</p>
  
  <p>I have SQL Server 2008 r2.</p>
  
  <p>So far I've only been able to automatically generate an sqlscript for all tables and views.  But the data wasn't included. </p>
  
  <p>OR is there any easier way to export data, tables, views, from one SQL Server to my ISP's SQL server?</p>
  
  <p>Regards
  Tea</p>