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!

more ▼

asked Apr 19 at 09:55 PM in Default

avatar image

41 3

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Apr 20 at 11:23 AM

avatar image

ThomasRushton ♦♦
42k 20 50 53

(comments are locked)
10|1200 characters needed characters left

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

Also you may check this

more ▼

answered Apr 20 at 04:55 AM

avatar image

421 3 7

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 19 at 09:55 PM

Seen: 60 times

Last Updated: Apr 20 at 11:23 AM

Copyright 2017 Redgate Software. Privacy Policy