Rails use MS SQL server database

Question

In my rails app, I need to use an existing MS SQL database. I have tried following this manual:

http://rubyrailsandwindows.blogspot.com/2008/03/rails-2-and-sql-server-2008-on-windows_24.html

I do not know how to do models, scaffolds, etc because rails cannot simply use another db. I didn't want to run rake db:migrate for my tables in the MS SQL database. What else do I need to write in the model? If simple: use tables from the MS SQL server's database, but I also want to solve problem with migrations, etc.

Are you wanting to hook Rails up to an existing database, or a new one? — Snips
– Snips, Commented Nov 22, 2012 at 16:07
Have a look at this question: stackoverflow.com/questions/4597570/… — mccannf
– mccannf, Commented Nov 22, 2012 at 17:17
@mccannf it is not exactly what i need... becouse from this existing mssql db i need generate fields in view too, etc... — byCoder
– byCoder, Commented Nov 22, 2012 at 18:05

Community · Accepted Answer · 2017-05-23 11:44:19Z

1

If you need to run your Rails up on top of the existing database and you want to make sure you can create all models that match existing tables, follow this guide:

Dump the schema into schema.rb using http://guides.rubyonrails.org/migrations.html#schema-dumping-and-you. I would actually use SQL mode of schema (config.active_record.schema_format = :sql ) and just use SQL Server tools to generate SQL file of the database schema and preserve it as db/structure.sql
After the database schema has been established, you can redirect tables and primary keys in your models using an approach outlined here: Putting Rails over top of an existing database

As an alternative to ActiveRecord altogether, you might consider DataMapper as it claims to work better with "brownfield" (i.e. already established) databases.

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Nov 22, 2012 at 18:16

Dmitry Frenkel

1,79612 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

mccannf Over a year ago

Yes, and then for each model you create, you can run rails generate scaffold_controller ModelName to auto create controllers and views.

byCoder Over a year ago

but will then i need to write all relations in models? has many, belongs?

byCoder Over a year ago

also i need to create all models?

Collectives™ on Stack Overflow

Rails use MS SQL server database

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related