Migrating Sql server DB to another Server

Question

Hello,
I am planning to migrate the some Sql server databases to another Server on same domains but some of the databases have cross connection dependency.
I mean some of the database either View or Stored procedure I found that it's calling to another database table so it referencing one or multiple databases in some of the stored procedures or views.

What's the best approach to migrate the database(s)?
To make it clean migration, I was thinking to do one by by so we can have thoroughly testing as it has some SSIS packages or jobs but after finding database objects dependency, looking the suggestions.

Thanks for your help!

Answer 1

During Migration, when i used DMA , it's also moving logins but need to know when i'm moving logins, it says that
"After the migration is complete remember, to validate your logins and permissions on the securable with those logins"
what exactly needs to be done, I know it's a strange question.
Is it migrating Sql Server with original password?
Is it SID will be same although we are migration to the new server?
Is it mapping correct with the selected user databases?

thanks for your help!

Answer 2

Hello,
anyone know DMA (SSMA) is using Full backup as COPY_ONLY to restore for Production DBS?
I am migrating bunch of Production Databases to new Production server which have hourly log backup also running so need to make sure that it's taking regular FULL Backup or COPY_ONLY Full Backup?