SQL Server versions

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: )

354 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: )

1,095 reads

Blogs

Gathering More Digital Data with Tile Slim

By

After my wallet misadventures, I ordered a Tile Slim to track my wallet. It...

Accessibility is not just about slides

By

Although I don’t write about it much on this website, I am on the...

Daily Coping 4 Aug 2021

By

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

Read the latest Blogs

Forums

Nested Join Alternative

By Jackie Lowery

Is there a better way to write this nested join query?  I'm concerned about...

How to determine whether SSIS is being used?

By jankovic

Hello I've inherited some dev environment which looks like was abandoned, but I'd like...

xml output from sql query

By Bruin

The script runs but gives me "no data to export"  I see data in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers