Hi, I have a question about the steps to duplicate and upgrade SQL server. Now, I have a windows 2008 32bit server and runs SQL server 2005 on it. Then I would like to build another server, which is windows 2012 64bit and runs SQL server 2008 on it. I need to duplicate everything from the first server to the second one and keep both of them running at the same time, such as reports and so on. What should I do? Any one knows the steps to finish this project? Appreciate it!
You could also look at the [DBATools PowerShell library] / module - there's a Cmdlet there called [Start-SqlMigration] that orchestrates a whole host of other processes to accomplish this sort of thing. : https://dbatools.io/functions/ : https://dbatools.io/functions/start-sqlmigration/