SQL Server Upgrade

Migrate and Upgrade SQL Instance (2014/2016) to 2019 version with 1 click

  • Script

The script includes these steps:   STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLESPERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]

2020-05-22 (first published: )

34 reads

Migrate and Upgrade SQL Instance (2014/2016) to 2019 version with 1 click

  • Script

The script includes these steps:   STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLES\PERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]

2020-05-22 (first published: )

417 reads

Blogs

Fun Fact: AWS RDS and system_health

By

Did you know that the system_health Extended Event session was running in your RDS...

Daily Coping 2 Jun 2020

By

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

TSQL Tuesday #127 Invite – Non SQL Tips and tricks

By

How about for this months TSQL Tuesday let’s do another month of tips and...

Read the latest Blogs

Forums

SSIS How to split a single string into multiple columns using Derived Column

By sabarishbabu

Hello, In my source Column having comma separated with text qualifier(“), I would need...

Licensing Audit Advice

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Licensing Audit Advice

Getting the Mean

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Mean

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers