Re: [R] Package for converting R datasets into SQL Server (create table and insert statements)?

2010-10-09 Thread johannes rara
Thanks, but I'm not looking for a function to save dataframes into a RDBMS. I'm looking for a function which creates CREATE TABLE and INSERT statements from a dataframe. -J 2010/10/5 Eric Lecoutre ericlecou...@gmail.com: Hi, You can have a look at RODBC and its function sqlSave. HTH, Eric

Re: [R] Package for converting R datasets into SQL Server (create table and insert statements)?

2010-10-09 Thread Gabor Grothendieck
On Sat, Oct 9, 2010 at 9:02 AM, johannes rara johannesr...@gmail.com wrote: Thanks, but I'm not looking for a function to save dataframes into a RDBMS. I'm looking for a function which creates CREATE TABLE and INSERT statements from a dataframe. If the reason you want that is so you can

Re: [R] Package for converting R datasets into SQL Server (create table and insert statements)?

2010-10-09 Thread Michael Bedward
Package RSQLite has a dbBuildTableDefinition that creates the CREATE TABLE statement for a given a data.frame. I think other db related packages for MySQL and PostgreSQL also have such a function. Michael On 10 October 2010 00:39, Gabor Grothendieck ggrothendi...@gmail.com wrote: On Sat, Oct

Re: [R] Package for converting R datasets into SQL Server (create table and insert statements)?

2010-10-09 Thread Spencer Graves
Have you considered the DBI and RODBC packages? I'm trying to do something like this myself right now, and a post of my own (to R-SIG-DB) produced recommendations for these two packages. Both have vignettes. Hope this helps. Spencer On 10/9/2010 6:52 AM, Michael

Re: [R] Package for converting R datasets into SQL Server (create table and insert statements)?

2010-10-09 Thread David Winsemius
On Oct 9, 2010, at 9:02 AM, johannes rara wrote: Thanks, but I'm not looking for a function to save dataframes into a RDBMS. I'm looking for a function which creates CREATE TABLE and INSERT statements from a dataframe. (My first comment is speculation that Eric was intending that you look

Re: [R] Package for converting R datasets into SQL Server (create table and insert statements)?

2010-10-09 Thread johannes rara
Thanks Michael! dbBuildTableDefinition is something I was looking for but it does not seem to support SQL Server table definitions (CREATE TABLE statements may vary between different RDBMS). Thanks anyway, -J 2010/10/9 Michael Bedward michael.bedw...@gmail.com: Package RSQLite has a

Re: [R] Package for converting R datasets into SQL Server (create table and insert statements)?

2010-10-05 Thread Eric Lecoutre
Hi, You can have a look at RODBC and its function sqlSave. HTH, Eric 2010/10/3 johannes rara johannesr...@gmail.com Hi, R contains many good datasets which would be valuable in other platforms as well. My intention is to use R datasets on SQL Server as a sample tables. Is there a

[R] Package for converting R datasets into SQL Server (create table and insert statements)?

2010-10-03 Thread johannes rara
Hi, R contains many good datasets which would be valuable in other platforms as well. My intention is to use R datasets on SQL Server as a sample tables. Is there a package that would do automatic conversion from the dataset schema into a SQL Server CREATE TABLE statement (and INSERT INTO