Can any one else please help me to confirm that migrations are broken against SQL Server 2008? I'm running Rails 2.2.2 and activerecord-odbc- adapter 2.0 gem. I've created a system DSN to my test database using an authenticated connection.
I've created a single migration to make a table with a few columns in it and when you run the 'rake db:migrate' the first time, everything works correctly. However, if you run it again (which shouldn't change anything) I get the following error 'rake aborted! S0001 (2714) [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'schema_migrations' in the database. I think the 'activerecord-odbc-adapter' gem isn't compatible with SQL Server 2008 as I've tested the same migration against SQL Server 2000 and that seems to work fine. Does anyone else know of another gem/ plugin that allows authenticated connections to SQL Server 2008 that works properly? Thanks :) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
