Micros RES 4.0

[sky1980]

We're running Micros RES version 3.2 today and starting to explore ver. 4.0.
We have written some custom SQL code which interacts directly with the Sybase database.
I understand that due to PCI standards the CC info is now encrypted, but are the other data tables and fields still clear?
Specifically, if we upgrade to ver. 4.0 will we still be able to use our SQL code outside of Micros? Can we still log into Sybase Central and read the data tables?
I assume this must be the case as Crystal is external to Micros and they need to read clear data as well.

Can someone with ver. 4.0 experience help me understand what specifically 4.0 did?

 

[michael2010]

You will be able to use most of your SQL code. However, some of the syntax will have to be modified since it upgrade the version of ASA from 6.x to 9.x. I had to do the same thing for some of my clients when going through this same upgrade. Nothing huge... join vs. outer join type of modifications.

Data can still be viewed in Sybase Central. You can create read only users and dba level users as needed to stay in PCI compliance.

4.x upgrades give you the ability to be PCI compliant is the major change. It upgraded the components it uses (ASA, Crytsal, OS, among a few others). It also has the stronger encryption requirements you mentioned earlier. Any field that does NOT have credit card data will remain clear.