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, Nov 22 '12 at 16:07
Have a look at this question: http://stackoverflow.com/questions/4597570/putting-rails-over-top-of-an-existing-database — mccannf, Nov 22 '12 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, Nov 22 '12 at 18:05

score 1 · Answer 1 · edited May 23 '17 at 11:44

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 '17 at 11:44

Community

1
1

answered Nov 22 '12 at 18:16

Dmitry Frenkel

1,708
11
17

1

Yes, and then for each model you create, you can run `rails generate scaffold_controller ModelName` to auto create controllers and views. – mccannf Nov 22 '12 at 18:22
but will then i need to write all relations in models? has many, belongs? – byCoder Nov 22 '12 at 20:00
also i need to create all models? – brabertaser19 Nov 22 '12 at 20:14

Rails use MS SQL server database

1 Answers1

Linked