Bulk inserts into SQL Server

Anyone used Ruby w/in a Rails app. to set up a bulk import file for MS
SQL Server?

I have to be able to insert up to ~50000 records into a table and
ActiveRecord one-at-a-time ain’t gonna cut it :).

I’m open, of course, to other, more Rails-y solutions, but plan to go
down the path of generating the appropriate bulk import file format from
my data.

Any advice/information is appreciated.

Thanks,
Wes

ActiveRecordExtensions (http://www.continuousthinking.com/ARE/import) is
a plugin that among other things does that. It only caters for mysql
currently, but you might find that it easy to enhance or at least give
you an idea on sensible strategies.

Fred

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs