Over a million developers have joined DZone.

Generate Database Script With Data From Database

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:
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

Java Software

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}