Cyberiafreak

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

How to recreate schema and data using SQL Script ??

Microsoft
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
place.

·        
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
L

Download it from here: http://www.microsoft.com/downloads/details.aspx?familyid=56e5b1c5-bf17-42e0-a410-371a838e570a&displaylang=en#QuickInfoContainer

Advertisements

July 12, 2007 - Posted by | Uncategorized

No comments yet.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: