On 12/15/05, Jamie Orchard-Hays <jamie-fswG1Ka7Iew@public.gmane.org>
wrote:>
> 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 Dec 15, 2005, at 10:11 AM, Peter Fitzgibbons wrote:
>
> > 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 ?
> >
> > --
> > ------------------------------
> > Joyeux Noël
> > ------------------------------
> > Peter Fitzgibbons
> > _______________________________________________
> > Rails mailing list
> > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> > http://lists.rubyonrails.org/mailman/listinfo/rails
>
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.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
--
------------------------------
Joyeux Noël
------------------------------
Peter Fitzgibbons
_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails