Creating DB script with data from Sql sever 2005

Creating Database script with data is quite easy for deploying an application with existing data. Anyone can create such script following these steps as dictated by diagrams. This process will be helpful to the people not having SQL server Management Studio installed.

• Window-1: Visual Studio: View>Server Explorer>Data Connections>Select One Connection>Publish to provider
  


• Window-2: Select a database > Next
  


• Window-3: Script to file > Next
  


• Window-4: Type of data to publish: Schema and Data >Next
  


• Window-5: Review Summary: >Next
  


• Window-6: Database Publishing Progress > Finish
  


• Window-7: Completed.