MyDoggieJessie (4/4/2014)
If you don't mind using SSIS - You can also use the transfer jobs, transfer logins, transfer SQL objects, and transfer master stored procedures tasks in SSIS to keep the 2 servers in sync
i think there is a caveat about the ssis transfer logins task, right? i believe it disables sql logns and assigns a random password. That's why sp_help_revlogin is preffered.
I just did an upgrade from one server to another, and i scripted out every item, including mail setttings and stuff.
Lowell