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

SQL Server Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

DATABASE MANAGEMENT AND ADMINISTRATION

SQL Server freebie: DDL Archive Utility for generating scripts

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 the same each time they're generated; other tools that generate DDL sc...

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Microsoft SQL Server Tools and Utilities
	Microsoft SQL Server Tools Guide
	How SQL Server 2008 components impact SharePoint implementations
	SQL Server Mailbag: Data restoration and DB property management
	SQL language crash course (just enough to be dangerous)
	Setting up SQL Server Service Broker for secure communication
	Microsoft SQL Server 2008 Resource Governor primer
	The sqlcmd utility in SQL Server
	Performance analysis tools for SQL Server
	Software security tools to improve your skills in a single day
	Surface Area Configuration and other security tools in SQL Server 2005

.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 stored procedures

.NET Development for SQL Server Research

Database Management and Administration

Password cracking tools for SQL Server

Using traces in SQL Server Profiler

Meet compliance requirements with improved database security practices

Hardening the network and OS for SQL Server security

Securing the server and database in SQL Server

How SQL Server 2008 components impact SharePoint implementations

Troubleshooting Distributed Transaction Coordinator errors in SQL Server

Achieving high availability and disaster recovery with SharePoint databases

Clearing the Windows page file and its effect on server performance

Deploying a SQL Server virtual appliance for Microsoft Hyper-V

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

ripts 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.

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