We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] Migrate SAP DB from SQL 2005 to SQL 2012

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from D. Caddick on Feb 1 at 8:57 PM
Hi,

There is no need to export/import there SQL data. You have two options.
1. Backup source database and restore to target database.
2. Use the detach/attach stored procedure sp_detach_ db and sp_attach_db.

Regards

---------------Original Message---------------
From: Pedro Taveira
Sent: Friday, January 31, 2014 9:04 PM
Subject: Migrate SAP DB from SQL 2005 to SQL 2012

Hi,

I'm analysing the possibility to upgrade SAP DB from SQL 2005 to SQL 2012.
Based on this, we have:
OS: Windows 2008 Standard
DB: SQL 2005

To

OS : Windows 2012 Standard
DB: SQL 2012

The idea is:
1- Install fresh machine in Windows 2012 and with SQL 2012
2- Update os necessary SAP SP's

3- Export DB from original system (SQL 2005)
4- Install SAP on new system (with W2012 and SQL 2012)
5- Possible Kernel update
6- Import DB to new system
7- Post-implementation


The first two steps I don't have any doubt, but the following steps I have doubts.
Can anyone explain how is this done? Is there any process description of this? Specially the export/import and Post-implementation processes?

Thanks!

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2014 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
D. Caddick  

Consultant
12 achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Have a technical question? Need to find IT solutions? Ask your peers in the Toolbox for IT community.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language