
	Home > SQL Server Tips > SQL Server Management > SQL Server freebie: DDL Archive Utility for generating scripts

SQL Server Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

SQL SERVER MANAGEMENT

SQL Server freebie: DDL Archive Utility for generating scripts

By Serdar Yegulalp, Contributor
11.17.2005
Rating: --- (out of 5)

Expert advice on database development

Digg This! StumbleUpon Del.icio.us

SQL Server's Data Description Language (DDL) allows you to write scripts that define data and data relationships in a database. It's used to load data into a database rather than create the database itself. So, if you're testing SQL Server, DDL scripts will quickly repopulate a database with test data or other needed objects; if you're trying to solve a problem in collaboration with others, DDL scripts can help replicate the exact conditions for testing on their own computer.

One problem with DDL scripts, however -- and with SQL Server in general -- is the lack of integration with any kind of source code control mechanism. Conscientious programmers use source code control systems, such as Microsoft's own Visual SourceSafe, to track and manage the different iterations of a given program's code. A database programmer working with test data and data structures would be inclined to do the same thing, but the mechanisms usually aren't there to support it.

DDL Archive Utility is a freeware utility that lets a database programmer create SQL Server 2000 DDL scripts that can be imported into a Microsoft Visual SourceSafe repository. DDL scripts produced through DDLAL are exactly

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SQL Server Management
	A first look at Microsoft SQL Server 2008 R2
	Maintaining high availability of SQL Server virtual machines
	Creating fault-tolerant SQL Server installations
	Using Microsoft Hyper-V for SQL Server consolidation
	Scaling up vs. scaling out with SQL Server 2008
	Migrating to SQL Server 2008 and leveraging new features
	Testing a SQL Server environment before an upgrade
	Does upgrading to SQL Server 2008 fit your business?
	Meeting business needs with SQL Server full-text search
	Using dynamic management views to improve SQL Server index effectiveness

.NET Development for SQL Server

Creating Windows PowerShell scripts to manage SQL Server 2008 instances

Manipulate column names in a SQL Server table

Code to restore SQL Server databases in VB.NET

Custom VB.Net scripting in SQL Server Integration Services

Retrieve images from SQL Server and store in VB.Net

Connect to SQL Server database with Visual Basics

Top 10 SQL Server development questions

Developing CLR database objects: 10 tips, 10 minutes

CLR architecture

CLR assemblies in SQL Server 2005

.NET Development for SQL Server Research

Microsoft SQL Server Tools and Utilities

Microsoft SQL Server 2008 Resource Governor primer

The sqlcmd utility in SQL Server

Performance analysis tools for SQL Server

Surface Area Configuration and other security tools in SQL Server 2005

Securing IIS and SQL Server as part of an online platform

Learning Guide: SQL Server tools

View SQL Server transaction logs using DBCC

Running analytical queries with Analysis Services

Fast Guide: Free SQL Server tools

SQL Server freebie: PromptSQL for word completion

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

ACID (SearchSQLServer.com)

data aggregation (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

the same each time they're generated; other tools that generate DDL scripts will create "phantom differences" each time they're run, which breaks compatibility with SourceSafe. DDLAL lets you also specify which database objects and data sets to script, so you don't have to waste time scripting objects you don't need. The program can also be scheduled (via Task Scheduler or another mechanism) to make repository backups of database objects on a regular basis.

The only database objects needed by the program itself are a set of tables and stored procedures installed by the application via the instArchUtil.sql script included with the program. These structures should not be modified by the end user, of course.

About the author: Serdar Yegulalp is editor of the Windows Power Users Newsletter. Check it out for the latest advice and musings on the world of Windows network administrators -- and please share your thoughts as well!

More information from SearchSQLServer.com

Tip: SQL Server freebie: TOAD for SQL Server

Tip: Free SQL Server monitoring with event forwarding

RSS: Sign up for our RSS feed on database development

Rate this Tip
To rate tips, you must be a member of SearchSQLServer.com. Register now to start rating these tips. Log in if you are already a member.
Submit a Tip

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

SQL Server Development - .NET, C#, T-SQL, Visual Basic

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy