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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 2005 -> 2012 transfer. Can you assist please?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jellybean
Starting Member

15 Posts

Posted - 04/14/2015 :  12:19:47  Show Profile  Reply with Quote
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

Sweden
30421 Posts

Posted - 04/14/2015 :  13:05:55  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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 - 04/14/2015 :  21:28:12  Show Profile  Reply with Quote
hi @swepeso,
can Copy Database wizard copy the system db or just the user created database? Thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000