Dear Members, I came across a requirement in my project where we are expecting few scenarios as mentioned below.. Please share your experience with regards to same - 1. Can SAP based application use SQL Server or Oracle as their backend. 2. If above answer is YES; then do we expect any out of turn or seperate process of Migration/Installation/testing of SQL Server DB with respect to Performance/Job Reports/DBA jobs. 3. If Encryption need to be implemented on such DB, do we expect any challenges OR we may expect same situation as for Java or .NET based Applications.
1. SAP applications are available on both SQL Server and Oracle. Both are supported. 2. I'm not sure how to answer this. Yes, there will be work involved with migration and testing. There will be performance tuning required. That's true of both Oracle and SQL Server. The solutions between the two will be different. Do you mean are there specific settings or configurations you need in SQL Server for dealing with SAP? It really depends on your system. When you purchase the software, the company will have specific recommendations. Use them. 3. Encryption in SQL Server will not require changes to application code in most cases. It does depend on how you implement the encryption on the database. But, if you have never implemented encryption and then you're adding it to an existing app, there's likely going to be changes needed in connection settings. [Here's a good white paper] from Microsoft discussing all the different implications of encryption. :