How to Upgrade sqlserver2000 to Sqlserver2005(Sapb2005)

[Former Member]

Hi,

How can i upgrade Sqlserver2000 to sqlserver2005 database.Previously i am working with Sqlserver 2000 Database now regarding requirement i had to upgrade Database in Sqlserver2005 without uninstalling Sapb12005 can anyone suggest me regarding this Issue.

very Urgent.

Regards

Nagababu

[former_member186095]

Hi Kandu,

you could directly restore the database that is backed up from SQL server 2000 to SQL server 2005. Prior to restore, you must create a new database in the SQL server 2005 by using SAP B 1 2005 if your SAP B1 is in the SQL 2005 by clicking choose company --> click new button. After creating new company, you can directly see it in the SQL server 2005. Then restore the back up. After restore, you can open the new company created with the database that has been restored.

I am not sure if previously your current SAP B1 installation is based on SQL 2000 or SQ 2005, but I need your info about this. If it is so, I suggest you to restore the common database from SQL 2000 to SQL 2005. I suggest it would be better to reinstall SAP B1 and use SQL 2005 as database server. Then restore the backup likewhat I have written in the 1st paragraph.

Rgds,

[Former Member]

Thank u for your information

currently i am using sapb1 2005 b Patch level 27 with 3 licenses.

i am using sqlserver 2000.

Now i want to change to sqlserver 2005.

can u help me the better procedure for this changing

without disturbing the databases.

Regards,

Nagabau

[former_member186095]

Hello,

You could directly change the common database server from SQL 2000 to SQL2005 in the add remove program (in the control panel). Select / highlight the SAP Business One, click change / remove button and after the screen install shield wizard welcome screen appears, click modify, click next --> select by ticking common database and demo in the select feature screen, click next --> edit data screen to select database server type. In this screen you choose SQL 2005, click next --> edit data server login screen,here you must fill the login screen, click next until finish.

If it is finished, you could backed up the production live database in the SQL 2000, and restore in the SQL 2005. It must be done after you have finished creating new database in the SQL 2005. If you change common database to SQL 2005, it means your production live database can be read or access if it has been restored in the SQL 2005. So, the database is still disturbed. The benefit is you do not have to reinstall the SAP B1.

Rgds,