DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Generate Database Script With Data From Database

12.19.2011
| 2267 views |
  • submit to reddit
        Database Publishing Wizard is very flexible and works with modes like schema only, data only or both. It generates a single SQL script file which can be used to recreate the contents of a database by manually executing the script on a target server.
 
You may find at following location in your machine:
 
File Name:
SqlPubWiz.exe
Path:
C:\Program Files\Microsoft SQL Server\90\Tools\Publishing

Download Database Publishing Wizard from here http://sqlhost.codeplex.com/wikipage?title=Database%20Publishing%20Wizard&ProjectName=sqlhos

<a href="http://www.java-forums.org/java-software/"><strong>Java Software</strong></a>