You administer a Microsoft SQL Server 2012 instance named SQL2012. You are in the process of migrating a database from a SQL Server 2008 instance named
SQL2008 to the SQL2012 instance.
You have upgraded a database from the SQL2008 instance by using the side-by-side migration technique.
You need to migrate the SQL Server logins from the SQL2008 instance to the SQL2012 instance.
What should you do?
To migrate SQL Server logins from a SQL Server 2008 instance to a SQL Server 2012 instance, you should use the Transfer Logins task in a Microsoft SQL Server Integration Services (SSIS) package. This task simplifies the process of transferring logins and their associated properties between instances of SQL Server. This method is specifically designed for the purpose of migrating logins, ensuring that all necessary details, such as passwords and server roles, are preserved during the transfer.
B!!!!!!!
Yup: https://www.sqlshack.com/migrate-logins-database-different-server/
Answer is B
Yes. It should be B
Should be B