SAP Fiori Installation

[Amarnath]

Hello Experts,

We have a requirement to build an exact copy of fiori production like fiori development. Development was built long back with Gateway server on a separate box with configuration windows server 2012 and with database SQL 2012.

Now we have a brand new box ready to install Gateway for production. We need to build it fro fiori from scratch.

Please guide me in these,,

1) Is there any procedure to install SQL with respect to SAP.

2) We would like build the exact copy using export and import method. Is this the best way to proceed?

3) If we do like this do we get all the RFC's , background jobs etc?

4) Do we need to take any caution while starting the system if we follow this?

5) Other than this if there is any best way to do this please suggest

Best Regards,

Amarnath

[former_member185239 · Accepted solution]

Dear Amarnath,

1) Is there any procedure to install SQL with respect to SAP.

You can use the script SQL4SAP to install the MS SQL server. You dont have to worry about the collation part of MSSQL.

If you use the setup.exe to install the Database , then you to select the collation SQL_Latin1_General_Cp850_BIN2 otherwise you will not able to install your SAP system.

2) You can use the export and import process to build the system. You can also use the backup and restore as well as attach n detach method in MSSQL.

If you use the backup/restore or attach and detach method , then you need to install the Database in mixed mode which will enable the sa user (Administrator user for MSSQL).So use setup.exe file to install the Database.

SQL4SAP script will install the MSSQL database server without enabling the sa user and then you will not able to logon to the MSSQL server to perform the backup/restore or attach/detach. Though there is another script which enable the sa user but in my case , it didn't work.

3. If we do like this do we get all the RFC's , background jobs etc?

You will get the all the RFC from development and background job. Later on you to point the RFC to production system which will be a part of post system copy.

4. Do we need to take any caution while starting the system if we follow this?

    If you are creating a system from production database , then you have to take precaution such as disable all     the RFC and suspend the jobs etc.Since you are using development system to build a production system then you have to take minor precaution.

5. Backup/restore or attach/detach method will be faster compare to Export and import.

With Regards

Ashutosh Chaturvedi

[Amarnath · Accepted solution]

Hello Ashutosh,

Thanks a lot. So If I am using SQL4SAP script I will not be able to use backup and restore method. Can I prefer setup method to install the database then?

Best Regards,

Amarnath

[former_member185239 · Accepted solution]

Dear Amarnath,

You have to use setup.exe file to install the database and not SAP4SQL.vbs

With Regards

Ashutosh Chaturvedi

[Amarnath · Accepted solution]

Hello Ashutosh,

1) We are requesting SIDADM, sapservice ID and password to be created by OS team.

2) Downloading MSSQL and installing it using setup.exe.

3) Take backup of Development box.

4) Restore New Production box with development backup in MSSQL.

5) Using SWPM we will choose database copy procedure and install a new system.

Guide me if I am wrong/any suggestions.

Best Regards,

Amarnath

[former_member185239 · Accepted solution]

Hi Amarnath,

Above procedure is correct.

With Regards

Ashutosh Chaturvedi

[Amarnath · Accepted solution]

Hi Ashutosh,

I will start my process and update again If I face any issues.

Best Regards,

Amarnath