Operating system and database migration from Sql 2000 to Sql 2008

[peervali_syed]

Hello All,

Hope you are doing great,i need a suggestion in the following scenario...

we have CRM 5.0 On win 2003 Server on 32 bit machine and dataabase is mssqlserver 2000..

now i would like to Upgrade to Application CRM 7.1 and os :windows 2008 r2 sp1 on 64 bit machine and database ms sql server 2008...

Please provide me the step by step process ,immediate response appriciated....

in brief:

oldsystem: New hardware:

(os)win 2003 server 32 bit (0S)win 2008 Server 64 bit

sqlserver 2000 (db) sqlserver 2008

CRM 5.0 CRM 7.1

Regards,

Syed

[peervali_syed]

thank you very much...

[former_member192997]

Syed,

We are planning to upgrade our EP 6.0(was 640) on sql2000 and windows 2003(x32) to NW 7.3 on sql 2008 windows 2008(x64). We are planning on system copy of  EP 6.0(was 640) from Source: on sql2000 and windows 2003(x32) to Target:  on sql2008 R2 and windows 2008 R2 (x64).This will be followed by direct upgrade from EP6.0 (was 640) to NW 7.3  I am mainly looking at the notes:

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=0001480906&nla...

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1476928

Since you took a similar approach, I would greatly appreciate if you could comment on this approach and provide me with any insights based on your experience.

Thank you!

VK

[former_member184473]

Hello Syed,

Check the following websites:

http://blogs.msdn.com/b/saponsqlserver/archive/2011/10/28/upgrade-path-to-sql-2008-r2-and-windows-se...

http://blogs.msdn.com/b/saponsqlserver/archive/2009/11/29/upgrade-to-sql-server-2008-or-sql-server-2...

Also, the mentioned note [1476928|http://service.sap.com/sap/support/notes/1476928].

Regards,

Eduardo Rezende

[peervali_syed]

Hello Edurado/Deepakkori,

Thank you very much for your help,

1) Migrate CRM 5.0 to Windows 2008 R3 SP2 64 bit with MSSQL 2008 .

You need to use homogenous system copy method using R3load . Refer Homogenous system copy guide.

You mean to say i have to install Windows 2008 R2 OS and Ms Sqlserver 2008 r2 database on new hardware

and take the system copy of our existing system by using homogeneous system copy and import it on new hardware by using sapinst.....

Please suggest ...

if we are taking the export and import it will success on WIN 2008 R2 AND MSSQL 2008 R2 DATABASE?...

Thanks,

Syed

[Former Member]

> 
> if we are taking the export and import it will success on WIN 2008 R2 AND MSSQL 2008 R2 DATABASE?...
> 
> Thanks,
> Syed

Please go with EXPORT/IMPORT method. This 'is' the way.

Thanks

[former_member188883]

Hi Syed,

Homogeneous system copy using R3load means using Export/import method.

Regards,

Deepak Kori

[peervali_syed]

Hi Deepak Kori/database SAP,

Thank you very much for your quick response,

I have little bit confusion here what i need to install on target system exactly?

I will take the export of the source system and before importing into the target system we need to install OS: Windows 2008 r2 only or OS and db mssql 2008 Server r2 is also needs to be installed?

for your information my source system runs on Windows 2003 Server(32 bit) and database mssqlserver 2000 sp4

Thanks,

Syed

[former_member188883]

Hi Syed,

You need to use SAPINST to install your target system using system copy option -> Target system installation.

You need to have Windows 2008 R2 first and then install database software MSSQL 2008.

When prompted for Export Dump location, provide details from the export taken.

Regards,

Deepak Kori

[peervali_syed]

Hello All,

Thanks to all it works,im closing this issue.

Regards,

Syed

[former_member188883]

Hi Syed,

You can follow this approach

1) Migrate CRM 5.0 to Windows 2008 R3 SP2 64 bit with MSSQL 2008 .

You need to use homogenous system copy method using R3load . Refer Homogenous system copy guide.

2) Then upgrade CRM 5.0 to CRM 7.01 on the new hardware.

I do not see any better method that this.

Regards,

Deepak Kori