Using SQL Prompt with SQL Change Automation in Visual Studio

preview_player
Показать описание

In this video:
00:20 - Overview of programmable objects in SQL Change Automation
01:15 - Overview of the offline schema model in SQL Change Automation
2:10 - Demo of refactoring a stored procedure (a programmable object) begins
7:30 - Saving the "offline edit" to the programmable object triggers option to deploy to development database
9:08 - Test full build and deploy of first committed change in VS Code with PowerShell components
13:15 - Demo of editing an index on a table with SQL Server Data tools and generating a migration script begins. This demo shows the "offline schema model"
20:19 - Deploy the edited migration script
22:40 - Perform build and deploy with PowerShell cmdlets
24:00 - Review release artifact
  1. Redgate Software
  2. SQL Change Automation
  3. SQL Prompt
  4. Static Code Analysis
  5. Kendra Little
  6. Visual Studio
Рекомендации по теме
Using SQL Prompt 0:25:30

Using SQL Prompt with SQL Change Automation in Visual Studio

Using Code Analysis 0:01:37

Using Code Analysis in SQL Prompt

Code Analysis in 0:00:31

Code Analysis in 30 Seconds with SQL Prompt | Redgate

SQL Prompt in 0:00:31

SQL Prompt in 30 seconds | Redgate

How to install 0:07:14

How to install SQL Prompt in SQL Server | Học viện Coder

Code Completion, Formatting 0:04:15

Code Completion, Formatting & Refactoring with SQL Prompt | Redgate

SQL Formatting in 0:00:30

SQL Formatting in 30 Seconds with SQL Prompt | Redgate

SQL Prompt Runs 0:03:04

SQL Prompt Runs in Google SQL Database

SQL Prompt Tips 0:01:35

SQL Prompt Tips | Redgate

SQL Prompt Pro 0:01:39

SQL Prompt Pro in Visual Studio - using placeholders

Use ChatGPT To 0:09:01

Use ChatGPT To Write SQL Queries From Scratch

SQL Prompt tips 0:43:09

SQL Prompt tips and tricks

Part 5 - 0:11:46

Part 5 - First Part of SQL Prompt in Redgate SQL Toolbelt Essentials

SQL Prompt Popular 0:00:46

SQL Prompt Popular Snippets: II (INSERT INTO)

Using Redgate SQL 0:04:06

Using Redgate SQL Prompt for Code Analysis

SQL Prompt Pro 0:01:05

SQL Prompt Pro in Visual Studio - code snippets

How to use 0:05:56

How to use sql in command prompt || Connect to Sql Server through Command Prompt || Ms Sql

SQL Prompt Tips 0:00:51

SQL Prompt Tips | Redgate

SQL Prompt - 0:00:59

SQL Prompt - SmartRename

SQL Prompt - 0:00:58

SQL Prompt - expanding the wildcard

SQL Prompt Tips 0:00:48

SQL Prompt Tips | #2 Casing Options | Redgate

SQL Prompt execution 0:01:08

SQL Prompt execution warnings

SQL Prompt column 0:01:13

SQL Prompt column picker

SQL Prompt - 0:00:07

SQL Prompt - Create and share SQL formatting styles

Комментарии
Автор

Is it possible to use Evolutionary Database Design (c# + SQL together) instead of the state based design Redgate tools seem so focused on? We can't use Flyway because it's Java based, but would love to somehow integrate DbUp with Redgate tooling so that our C# check ins (git) and our sequenced SQL scripts (in the dbup project) can be checked in simultaneously. This would allow our C# tests to assume a very specific db schema is present in our CI/CD pipeline.

chrisbordeman