we would like to change the SQL server 2000 on the SAP B1 2005A SP01 PL 45 to SQL Server 2005.
I need your guidance how to do that. The consideration things are as follows:
1. What are the steps need to do that ?
- Removal SQL server 2000
- Removal SAP B1 2005A
- etc ??
2. Which SQL server 2005 will I use, standard or enteprise and what are the benefit and weakness of each one of them ?
3. How to make connection setup in the new SQL server installation?
4. Do I need to remove current connection setup ?
Pls give advice. TIA