question

yxzhou624 avatar image
yxzhou624 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!
reporting_servicessql 2008windows-server-2012windows-server-2008sql 2005
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jason_clark03 avatar image
jason_clark03 answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
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/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.