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

Read more: http://feeds.dzone.com/~r/dzone/snippets/~3/nox5Z1-Z4ao/14229