Hi, I have a very large ".mdf" database (36 GB) that I want to import to R. I'm using a computer with 64 GB of RAM, running on windows server 2008 R2 with SQL. Could anyone guide me through the process. I have absolutely no idea what to do. Thanks, Mauricio Romero [[alternative HTML version deleted]]
And we have little idea what the format of a ".mdf" file is. (It has multiple meanings, see e.g. http://www.delphifaq.com/faq/f777.shtml.) Since you mention 'with SQL', maybe you meant 'Microsoft SQL Server', some (older?) versions of which have '.mdf' files. The short answer in that case is that you load the file into SQL Server and access it from R via ODBC -- but that is a discussion for r-sig-db (you'll need to subscribe to post), not for here. On Sun, 8 May 2011, Mauricio Romero wrote:> Hi, > > > > I have a very large ".mdf" database (36 GB) that I want to import to R. > > I'm using a computer with 64 GB of RAM, running on windows server 2008 R2 > with SQL. > > > > Could anyone guide me through the process. I have absolutely no idea what to > do. > > > > Thanks, > > > > > > Mauricio Romero > > > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >-- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595
You need to go study SQL Server database administration for awhile... and this is not the place for that. (A book is advisable.) You will also need to set up an ODBC Data Source Name for open connectivity to that database. You should also start learning how to use RODBC to send SQL statements to the database server, and how to use them to select aggregate data or small subsets, because you almost certainly won't be able to import the whole dataset. There is the big picture. Almost none of those subjects are topical on this mailing list. Good luck. --------------------------------------------------------------------------- Jeff Newmiller The ..... ..... Go Live... DCN:<jdnewmil@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --------------------------------------------------------------------------- Sent from my phone. Please excuse my brevity. Mauricio Romero <mauricio.romero@quantil.com.co> wrote: Hi, I have a very large ".mdf" database (36 GB) that I want to import to R. I'm using a computer with 64 GB of RAM, running on windows server 2008 R2 with SQL. Could anyone guide me through the process. I have absolutely no idea what to do. Thanks, Mauricio Romero [[alternative HTML version deleted]]_____________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]]