asked
Duplicate and Upgrade SQL Server
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 can use the Copy Database functionality in SQL Server Management Studio. Right-click the database, select "Tasks", "Copy database". If you can take the database offline, you can also choose to detach it, copy the files to the new server, and then reattach the database after. See also the [Microsoft][1] Also you may check [this][2] [1]:
http://technet.microsoft.com/en-us/library/ms188664.aspx [2]:
http://stackoverflow.com/questions/12402367/how-to-copy-sql-server-database-from-one-to-another-server-without-any-backups
You could also look at the [DBATools PowerShell library][1] / module - there's a Cmdlet there called [Start-SqlMigration][2] that orchestrates a whole host of other processes to accomplish this sort of thing. [1]: https://dbatools.io/functions/ [2]: https://dbatools.io/functions/start-sqlmigration/
17 People are following this question.
