INSYNCVA

SQL Server Documentation for Disaster Recovery, Migrations and Tiering

SQL Transcriptase

https://github.com/gwalkey/SQLTranscriptase

The SQL Server documentation you wish you had last year

Scripting out of important SQL Server objects contained both within and outside a Database should be done for these use cases:

  • Documentation
  • Migration
  • Disaster Recovery
  • Prod/Test/Dev/UAT Tier standardization

Most Backup software only gets the Database Schema and Data.

Many SQL Server objects live above the Database, at the Server level and are not captured.

What if you just wanted to move a TDE database or backup the PKI?

By scripting out these objects in a text format useful to DBAs, you can quickly restore/move/replicate these objects around the computing environment.

Use Cases

1) Documentation of your SQL servers for internal Wiki/Knowledge-bases or DBA/DEV training.

2) Migrations of SQL Servers to new hardware, Windows, SQL or 32->64 bit upgrades.

3) Disaster Recovery to quickly restore critical line-of-business SQL Servers, even before the data is located.

4) Source Control code and projects management and integration into a Source Control System

5) Environmental Consistency for creation of objects on other servers

6) Change Management until SSDT Database Projects can do docs and run Diffs on them

7) Standardized Testing Tiers so that Test, Dev, UAT servers are like Production

Requirements

687474703a2f2f7777772e696e73796e6376612e636f6d2f696d616765732f474f54472d5374696c6c5f322e6a7067

Leave a Reply