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.
| 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 |
 |
|
|
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 |
|
|
|
|
|
|
|
|
2005 -> 2012 transfer. Can you assist please?