This post originated from an RSS feed registered with .NET Buzz
by Brendan Tompkins.
Original Post: Building the WSMQ SQL Sever Database Installer
Feed Title: Brendan Tompkins
Feed URL: /error.htm?aspxerrorpath=/blogs/brendan.tompkins/Rss.aspx
Feed Description: Blog First. Ask Questions Later.
As part of our release of the WSMQ
1.0 Beta (SQL Server Version) installer, we had to build an installer that
would install our database. In the past, I've created database installers by
hand, storing SQL Scripts in resource files, and doing the logic around
installation options by hand.
With the latest version of WSMQ, I used Red-Gate's SQL Packager
tool, which will completely package a database, all schema, and user
information, as well as the data, for your database, into either a C# project
which you can adapt and customize, or into an .exe which you can drop into your
installer project.
The SQL Packager packages the schema and contents
of Microsoft SQL Server databases so that installing a database is much simpler.
SQL Packager is used for:
Packaging a database structure for installation or deployment
Packaging database data for installation or deployment
Packaging both data and structure for installation or deployment
Updating existing databases by packaging up changes of data and
structure
Compressing your package for reduced storage overhead and easier and faster
deployment and distribution of databases
SQL Packager does this by creating a .NET
executable that can recreate the database, or the update of the database, that
you need on other machines.
David
has also blogged about using SQL Packager in the past... So, suffice it to
say, it really works as promised. Something that used to take me days of coding
and debugging was accomplished in less than an hour. You gotta love
that!
Previous Topic
