Cool Tips‎ > ‎

SQL Server Migration Toolkit

 

Title

Description

Applicability

 

Get Unused Databases

INFO: Check if there are any databases that have not been used since the last SQL Server restart

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017



Get Replication Details

INFO: Get a list of Replication publications, subscriptions and articles.  Must be run against the Distribution database

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Generate Backup Scripts

MIGRATE:  Generate scripts to back up all User DBs on the source server

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Migrate Backup Files

MIGRATE:  Generate scripts to copy all backup files from the source server to destination server (using XCOPY)

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Generate Restore Scripts

MIGRATE: Generate restore scripts for all migrated DBs on the destination server.

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Migrate all logins and Database Security

MIGRATE:  Generate a script to create all logins, users and database security from the source database

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Generate Database Offline-Online Scripts

MIGRATE:  Generate scripts to take old DBs offline/online 

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Remove Permissions from a Database

MIGRATE - Generate code to remove all permissions/rights from a DB.  Useful if the old DB is to remain online for reference only

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Relocating System Databases

MIGRATE - Notes on how to move system databases.  Not something that should be the first choice, but included for completeness

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

 

Comments