Richard Sutherland


SQLServerCentral Article

Open Source SQL DDL Scripting Tool

Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code.

5 (5)

2008-03-03 (first published: )

9,945 reads

Technical Article

Script SQL Server DDL

Scripting SQL Server DDLRichard SutherlandIf you buy into the theory that all database objects should be contained in a source management system such as Visual SourceSafe, and that deployment of database projects should be done from the source management system, then the manner in which Microsoft's Visual Studio 2005 Team Edition for Database Professionals [a.k.a., […]

3.67 (3)

2007-08-20 (first published: )

1,333 reads

Technical Article

Script SQL Database DDL

This tool scripts out SQL Server 2000/2005 database objects to individual files in a manner which mimics Microsoft's Visual Studio for Database Professionals [aka, "Data Dude"]. These files can then be placed under proper source management control. An entire database is scripted in one call.Alternatively, it provides a way to simply document the contents of […]

2.33 (3)

2007-03-12 (first published: )

2,252 reads

Blogs

Daily Coping 21 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using dbachecks for CIS Security Checks

By

Well back at the end of 2019 I finished writing most of the checks...

How to tell if Change Data Capture (CDC) is working as expected

By

I’m not sure how many of you use Change Data Capture (CDC) on your...

Read the latest Blogs

Forums

Online SQL Server Monitoring

By Hamid-Sadeghian

Hi everyone. I want to monitor SQL Server live such as Activity monitor. I...

SSIS SFTP using WinSCP

By water490

Hi I am using WinSCP to create a SFTP task by following this guide:...

SSRS reports

By AryaanHaigh

Hi, I need to delete multiple SSRS reports from report portal. Is there any...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers