on 07-14-2015 10:56 AM
Hello All,
Can I connect to two different database servers/instances parallelly to one application server(SAP)?
Does it not create a problem in accessing the content of table with the same name on different database servers/instances?
If answer to above is yes where in the basis should I do it?
There's a big database table where the data needed to be moved but still accessible to SAP server. Archiving is not a solution for us
Thanks
Hi Cisco,
1) You can connect your SAP application server to an external database running SQL Server through DBCON: Note 1601608, and also this blog post:
2) Or do you mean you want to have 2 different back-end database servers while your application server switch between then?
In case of 2), I'm not sure this will work and it is mostly not supported by SAP.
Regards,
Luis Darui
SAP Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Hope the requirement is just for the single table to be moved out of the SAP database. Not sure why archiving is not applicable because you can still able to access the content of the table after archiving is done.
Regards,
Raja. G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Cisco
You can perform Normal SAP instalaltion either Standalone or Distributed system with MS Sql 2012 DB, and do the DB replication to another instance using MS Sql 2012 Alwayon with 4 secound replication, refer the Microsoft link and SAP Note
Overview of AlwaysOn Availability Groups (SQL Server)
1772688 - SQL Server AlwaysOn and SAP applications
Regards
SS
Hi Cisco,
In that case i would prefer to go with archiving as you can still access those contents and able to use the table at SAP level. Otherwise you can consider using the external database as mentioned by Luis and Sriram, it depends upon the usage of the table and the complexity.
Can you let us know why are you not prefer for archiving as it is the standard approach for growing tables?
Regards,
Raja. G
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.