Migrate Logins from SQL Server 2008 or 2008 R2 to SQL Server 2014 or SQL Server 2012 - SQL Server DBA Tutorial

In this video you will learn how to migrate Logins from SQL Server 2008 and 2008 R2 to SQL Server 2012 as well as 2014.
Video illustrates following:

1- How to use MS Login Transfer script on Source (SQL Server 2008R2) server
2- What are the limitations of Transfer Login Script
3- How to manually add Server roles of a login on Target server
4- How to run out of Login script on SQL Server 2014 to transfer logins

How to Migrate Logins from SQL Server 2008/2008R2 to SQL Server 2012 or SQL Server 2014

1 comment:

  1. Thanks for sharing the article, and more importantly, your personal experienceMindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story, since I can certainly relate and I think others can too