SQL Server Knowledge Sharing Network (SqlServer-qa.net)

SELECT [Whims_and_Fancies] from [my_SQL_Server_Knowledge];

Database Build tool for SQL Server 2005

In the current world of open source programming there are many tools out there that can provide help to you day-to-day tasks.

But as a professional you will not be inclined to use each and every product that is available free/beta on the market. Similarly for the database scritping SQL Server Management Studio has been enhanced to provide much flexibility to the SQL Server users. Same as to script out and find differences in SQL Server schemas we need a flexible tool to reassemble your scripts and deploy them easily.

Database Build Tool has been developed by [mmcquillan] which I have used and helped me to get what I want.

This tool provides a means of combining the scripts into a single SQL file or have them run against a database in an order you specify. There is also an option for keeping track of which scripts have been applied to a database to help deploy schema changes in a much easier way.

Be aware that this tool requires SQL 2005 be installed to make use of the SMO libraries and to download:

Runtime Binary dbb.zip

Comments

No Comments

About satya

SQL Server MVP. SQL Master, Speaker & SQL Server helper. 16+ years of IT experience in which as a Sr. DBA and Technical Design Lead in sectors of Banking, Stock markets & Investment Banking, Manufacturing & consulting.
Out of professional activities : Moderator - SQL Server Performance forums & MSDN forums in addition to my homepage above. Active member of most of the SQL Server community forums.

This Blog

Syndication



© 2000 - 2007 vDerivatives Limited All Rights Reserved.