Migrate SQL Server databases easily with dbatools - Jess Pomfret

preview_player
Показать описание
SQL Server migrations can sometimes be challenging and stressful. Using dbatools, an open source PowerShell module, we can quickly and easily migrate databases and other associated objects from one instance to another. We'll cover a couple of different options that can be used for all sizes of databases.

Never again let a SQL Server migration cause you worry.
Рекомендации по теме
Комментарии
Автор

I have attempted to use the Start-DBAMigration tool which is supposed to copy logins. I always seem to encounter the issue of having the databases transfer after logins are copied, leading to a bunch of errors indicating user permissions can't be set because "database does not exist". How can logins be copied and permissions set before the database is transferred? Is there a way around this, or do I need to do the migration, accept the errors, and then run an additional Copy-DbaLogin after the migration? Am I doing this wrong?

kylenelson
welcome to shbcf.ru