Thanks to everyone. I think that I have enough to send to the DBA's. Good info here and I also received some info from our Remedy support partner. All this should help. Gotta love ARSList!
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Friday, January 17, 2014 10:52 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle to MSSQL ** Tommy, BMC has customers on both Oracle and MS SQL in significant numbers. UNAUDITED but from what we see, the most used database is MS SQL (maybe 60% and then Oracle in the say 30% or a bit more range and others in the less than 10%). Smaller customers are much higher on the MS SQL side. Enterprise customers tend to be more heavily on the Oracle side. The Remedy On Demand (the SaaS offering) system runs on MS SQL for all customers. The capabilities of the database are in the same ballpark - the 8.1 release of the AR System and the final completion of the work by Oracle has solved the case insensitive difference and Oracle finally has full case insensitivity option like SQL Server has had for years which closes the main functional difference between the databases. In general, decisions are made based on in house expertise with a database - a lot based on what other products they are using use as the database. Hardware things are on is an issue of course given that MS SQL runs only on Windows. Either database will do a good job for you. BMC has large customers on both databases with large data volumes (millions of records) and large number of users (thousands of concurrent users). I hope this is useful, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tommy Morris Sent: Friday, January 17, 2014 8:25 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Oracle to MSSQL ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. "My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage?" Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I'm just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn't even have to be real current. Tommy Morris _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
