Migrations on SQLServer?


#1

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 ?


#2

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


#3

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