On Tue, Mar 25, 2014 at 4:26 PM, Javier Valencia < [email protected]> wrote:
> Is anyone using R:Base as a front end to a MS SQL Express database? > What issues have you encountered using a R:Base front end? > Did you find any performance issues? > Any suggestions, recommendations? > Is there a utility that would convert the database structure? > > Javier, I did a proof of concept on this about 3 years ago, and it is very feasible. The most important thing is that you will likely want to redo your 100+ views to be native to the MSSQL database (rather than R:BASE views based on ODBC tables.) That's especially true for multi-table joins in views, or GROUP BY views. The R:BASE view would be unable to calculate the best ways to retrieve rows from the foreign tables to assemble the view. You want MSSQL to figure out that stuff. (Unless something has changed drastically in one or both platforms in the last 3 years or so.) Database conversion is not a problem, there are a lot of ways to do that. Date datatypes don't match up perfectly, but that won't take you long. Obviously any R:BASE functions in your schema will have to be redone, and any stored procedures or triggers. The customer I did the proof of concept for stayed in R:BASE. Overall costs were going to be ridiculous otherwise. Razzak has a lot more details, I'm sure. It's in his San Diego curriculum. Bill
