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

[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 statements)?

For example.

> str(cars)
'data.frame':	50 obs. of  2 variables:
 $ speed: num  4 4 7 7 8 9 10 10 10 11 ...
 $ dist : num  2 10 4 22 16 10 18 26 34 17 ...
>

would become

create table dbo.cars (
              id int identity(1,1) not null,
              speed int not null,
              dist int not null,
              constraint PK_id primary key clustered (id ASC)
              on [PRIMARY]
              )

insert into dbo.cars
    values (N'4', N'2'),
              (N'4', N'10'),
              (N'7', N'4'),
               etc.

-J