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

Java Software
Topics:

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

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

{{ parent.tldr }}

{{ parent.urlSource.name }}