On Mar 3, 8:45 am, "Steven R. Elliott Jr" <[email protected]> wrote: > Hello friends, > > I have been asked to write front-end for an accounting system that would > allow customers to view their bill and pay online, reconcile their bill, > add/delete people that they are paying for etc. The database that I need to > use is already in existence and is SQL Server 2008; has anyone had > experience doing this sort of project? I would be interested to know how you > proceeded. I am using a Mac and most everything I have read is that I should > be developing this on a windows box and on the same machine as the database > which doesn't make much sense. > > I am trying to figure out the best way to get started but seem to be having > a mental block. > > Any help would be greatly appreciated. > > Thanks > Steve
Hi Steve, Rails apps can definitely talk to SQL Server 2008, and you can develop the Rails app on our mac like normal. You can probably use sqlite in development mode, and use sql server in production, but there are a few things to keep in mind: 1. You'll need to get the SQL Server activerecord adapter, and reference it from your database.yml 2. SQL Server won't run on a Mac, so you'll need to somehow access an instance of sql server to test with. If they can give you the full DSN string to their server (hopefully a testing server), you'll be all set. 3. If you're expected to follow non-Rails standards for table/column naming conventions, you'll have to just make sure you tell your model classes about it. Here's a good post about setting up your database.yml for sql server: http://rubyrailsandwindows.blogspot.com/2008/03/rails-2-and-sql-server-2008-on-windows_24.html Hope this helps Jeff www.softiesonrails.com www.pragprog.com/titles/cerailn -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
