Forum: Ruby on Rails Migrations on SQLServer ??

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
3203ed0e608d3bfae1e31282e629ffa2?d=identicon&s=25 Peter Fitzgibbons (Guest)
on 2005-12-15 16:12
(Received via mailing list)
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 ?

--
7a966bb1534f0ea863bc9ffe65ae449f?d=identicon&s=25 Jamie Orchard-hays (jamieorc)
on 2005-12-15 17:06
(Received via mailing list)
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
3203ed0e608d3bfae1e31282e629ffa2?d=identicon&s=25 Peter Fitzgibbons (Guest)
on 2005-12-15 18:09
(Received via mailing list)
On 12/15/05, Jamie Orchard-Hays <jamie@dang.com> wrote:
> > Hello all,
> > Peter Fitzgibbons
> > _______________________________________________
> > Rails mailing list
> > Rails@lists.rubyonrails.org
> > http://lists.rubyonrails.org/mailman/listinfo/rails
>
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> 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:in
`in
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:in
`table'
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:in
`each'
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:in
`dump'
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:in
`open'
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:in `execute'
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:in `execute'
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:in `run'
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:in `run'
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

--
This topic is locked and can not be replied to.