Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 2005 -> 2012 transfer. Can you assist please?

Author  Topic 

jellybean
Starting Member

15 Posts

Posted - 2015-04-14 : 12:19:47
Hi everyone,

I hope I'm in the right forum. Apologies if I'm not. Okay - here is my problem. Can you help me please? I want to transfer everything from a Sql Server 2005 R2 Enterprise to a Sql Server 2012 R2 Standard. That means databases, data, permissions, users, indexes (if possible), constraints (if possible), logins etc...
The source server will then be switched off ie not used anymore.

The database servers are on separate boxes.

I believe the best way to do this is with log shipping? Is that correct? Do I initiate the log-shipping process from the source or the destination? Can anyone help me please? Any comments/suggestions/user-experiences are much appreciated.

Thanking you,
J.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2015-04-14 : 13:05:55
I would simply use the Copy Database wizard...



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

bokswager
Starting Member

2 Posts

Posted - 2015-04-14 : 21:28:12
hi @swepeso,
can Copy Database wizard copy the system db or just the user created database? Thanks
Go to Top of Page
   

- Advertisement -