question

vivek1982s avatar image
vivek1982s asked

How to work on SAP based Appl. with SQL Server

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.
sql-server-2008sap
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
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][1] from Microsoft discussing all the different implications of encryption. [1]: http://msdn.microsoft.com/en-us/library/cc278098(v=SQL.100).aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.