"Fortunate are those who take the first steps.” ― Paulo Coelho

How to recreate schema and data using SQL Script ??

SQL Server Database Publishing Wizard 1.1

Yesterday I had a problem in generating scripts for master tables
which contains images and audio columns stored as VarBinary type, after enough googling and trying some third
party software, I really found this free tool from MS for script generation as
useful. It is really  useful when you need to generate script for default
data in a tables and schema during project  implementation phase at client

It generates a single SQL script file
which can be used to recreate a database (both
schema and data)

Helps developer to rollout the
scripts in a easy way during installation and distribution

(+) It
generates script for functions, SP’s

simple to use

(+) it generates
script for DataType – VarBinary(Max) ..i.e. for images, audio, video
stored in a table

(-)  There
is no option to generate script for a particular selected table or SP’s

Download it from here:


July 12, 2007 - Posted by | Uncategorized

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: