SFSSUG: DLM Training Workshop – Database Continuous Integration

Ready to do database continuous integration (CI) as part of Database Lifecycle Management?  Come to this workshop and take the next step in Database Lifecycle Management with Redgate’s Certifed Partner, Esteban Garcia.

For full details of the workshop outline visit the Redgate training page.

You’ll learn how to:

1. Link your source control repository to a build system
2. Trigger database builds automatically when you make a change
3. Use Redgate’s DLM tools to test your database changes
4. Lay the foundations for package-based deployment of your database

Are you ready for this workshop?

To get the most out of this workshop, you should:

• Have your database in source control
• Be familiar with source controlling a database using SQL Source Control
• Be looking to get a CI process set up

If you’re not there yet, never fear – come and learn how to get started at one of Redgate’s Database Source Control workshops.

Workshop outline

• Introduction to Database Lifecycle Management (DLM)
• Continuous integration (CI): an overview
• CI & Redgate DLM tools
• Automating builds
• Lunch
• The SQL CI plugin
• Introduction to SQL Test
• How to automate tests
• Tracking changes across environments with DLM Dashboard
• Networking

Equipment

It’s essential you bring a laptop with you – you’ll need it for the hands-on exercises. It should fit this spec:

• Windows 7 or later (recommended)
• Able to run a web browser and the Microsoft Remote Desktop client
• 1366×768 resolution (minimum)

Who should come?

Anyone who’s interested in doing CI with SQL Server.

Previous attendees have had job titles like Developer, Lead Developer, Development Team Leader, SQL Server DBA, Senior SQL Server DBA, Database Systems Manager, Systems Developer, and Database Architect.

Tools you’ll use in this workshop

• DLM Dashboard
• DLM Automation Suite
• SQL Source Control
• SQL Test
• NuGet
• Subversion
• TeamCity