# Bulk inserts into SQL Server

**URL:** <https://www.ruby-forum.com/t/bulk-inserts-into-sql-server/74194>\
**Category:** Rails\
**Created:** [November 1, 2006, 7:03am UTC](https://www.ruby-forum.com/t/bulk-inserts-into-sql-server/74194 "2006-11-01T07:03:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![weyus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/7ab992/32.png) [@weyus](https://www.ruby-forum.com/u/weyus)\
**Post date:** [November 1, 2006, 7:03am UTC](https://www.ruby-forum.com/t/bulk-inserts-into-sql-server/74194/1 "2006-11-01T07:03:47Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![weyus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/7ab992/32.png) [@weyus](https://www.ruby-forum.com/u/weyus)\
**Post date:** [November 1, 2006, 1:24pm UTC](https://www.ruby-forum.com/t/bulk-inserts-into-sql-server/74194/2 "2006-11-01T13:24:42Z")

</div>

ActiveRecordExtensions ([http://www.continuousthinking.com/ARE/import](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