# Using fixtures without dropping existing data

**URL:** <https://www.ruby-forum.com/t/using-fixtures-without-dropping-existing-data/89451>\
**Category:** Rails\
**Created:** [March 20, 2007, 4:02pm UTC](https://www.ruby-forum.com/t/using-fixtures-without-dropping-existing-data/89451 "2007-03-20T16:02:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![stickstone](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/6f9a4e/32.png) [@stickstone](https://www.ruby-forum.com/u/stickstone)\
**Post date:** [March 20, 2007, 4:02pm UTC](https://www.ruby-forum.com/t/using-fixtures-without-dropping-existing-data/89451/1 "2007-03-20T16:02:32Z")

</div>

Using fixtures for testing in rails is an awesome idea, but  
unfortunately i don’t have an extra instance of oracle running just so  
my rails tests can hammer it (i have to share a testing database).

Is there a way of using transactional fixtures without having them blow  
away the entire table when they load?

Thanks,  
-Brian