What issues will I have if I take sql 2005 on 32bitOS TO sql 2005 on 64bit?

[MPGraziano]

Last Year our SolMan was installed on 32bit OS, with SQL 2005 on Windows Ent. Edition (UNICODE).

I am preparing to migrate it to 64bit OS, and want to get there as quickly as possible without jepordizing the data integrity.

I was thinking that rather than doing a data export and import, that I could simply do a detach/attach of sql 2005

On the NEW server with 64bit OS My plan is to install SolMan 7.0 UNICODE & SQL 2005

If anyone has had experiences with this I would really appreciate tapping into your experience

Thank You in Advance

Regards,

Maria

[Former Member · Accepted solution]

please refer to note 799058, Setting Up Microsoft SQL Server 2005

[Former Member]

Hello Maria,

We have made a system copy in similar way and our systems were running fine without any issues for the last 6months. For your kind information its ABAP+JAVA portal system.

Regards,

Anandh

[MPGraziano]

so what method did you use?

[Former Member]

Hello Maria,

We have used attach and detach method. We used the system copy option in the installation master for the java instance. Search for SAP notes for more detail - i dont have the right note handy.

Regards,

Anand