Migrations on SQLServer?

Hello all,

I’ve spent a while looking for a sniff of this on the wiki or google at
large…

Does migrations work for SQL Server on 1.0 ?

Should do. The docs say it is. I’ll be trying it at some point soon,
but we’re developing with SQLite and later integrating with the
legacy SQL Server.

Jamie

On 12/15/05, Jamie Orchard-Hays removed_email_address@domain.invalid wrote:

Hello all,
Peter F.


Rails mailing list
removed_email_address@domain.invalid
http://lists.rubyonrails.org/mailman/listinfo/rails


Rails mailing list
removed_email_address@domain.invalid
http://lists.rubyonrails.org/mailman/listinfo/rails

Hello all,

Here’s the failure I’ve received on rake db_schema_dump --trace

Rails 1.0.0
Microsoft MDAC 2.8 SP1
DBI::ADO # $Id: ADO.rb,v 1.6 2002/07/03 16:48:35 mneumann Exp $

This error smells A LOT like the same error on AbstractAdapter#log that
SQL
Server throws when there is a trigger on the target table…

Anyone have some advice for this?

C:\ruby\dev\buildview>rake db_schema_dump --trace
(in C:/ruby/dev/buildview)
** Invoke db_schema_dump (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db_schema_dump
rake aborted!
DBI::DatabaseError: Count
OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server
ITransaction::Commit or ITransaction::Abort was called, and object
is
in a zombie state.
HRESULT error code:0x80020009
Exception occurred.: EXEC sp_helpindex buyers
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in
`log’

C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/sqlserver_adapter.rb:291:in
ex ecute' C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/sqlserver_adapter.rb:405:inin
dexes’
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/schema_dumper.rb:75:in
indexes' C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/schema_dumper.rb:71:intable’
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/schema_dumper.rb:47:in
tables' C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/schema_dumper.rb:45:ineach’
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/schema_dumper.rb:45:in
tables' C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/schema_dumper.rb:14:indump’
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/schema_dumper.rb:8:in
dump' C:/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/tasks/databases.rake:20 C:/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/tasks/databases.rake:19:inopen’
C:/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/tasks/databases.rake:19
C:/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/tasks/databases.rake:17:in
call' C:/ruby/lib/ruby/gems/1.8/gems/rake-0.6.2/lib/rake.rb:202:inexecute’
C:/ruby/lib/ruby/gems/1.8/gems/rake-0.6.2/lib/rake.rb:202:in each' C:/ruby/lib/ruby/gems/1.8/gems/rake-0.6.2/lib/rake.rb:202:inexecute’
C:/ruby/lib/ruby/gems/1.8/gems/rake-0.6.2/lib/rake.rb:180:in invoke' C:/ruby/lib/ruby/gems/1.8/gems/rake-0.6.2/lib/rake.rb:1454:inrun’
C:/ruby/lib/ruby/gems/1.8/gems/rake-0.6.2/lib/rake.rb:1454:in each' C:/ruby/lib/ruby/gems/1.8/gems/rake-0.6.2/lib/rake.rb:1454:inrun’
C:/ruby/lib/ruby/gems/1.8/gems/rake-0.6.2/bin/rake:7
C:/ruby/bin/rake:18:in `load’
C:/ruby/bin/rake:18