Hello all,
I’m trying to initialize my migrations against a current database
implementation.
rake db:schema:dump runs without error.
The resulting schema.rb is pasted below, along with my database.yml
Can one of you point me in the direction of enlightenment?
–
Apple MacBook. Black. It’s the new White!
Peter F.
================== database.yml =================
================== end database.yml ===============
development:
adapter: sqlserver
database: buildview_dev
host: localhost
username: user
password: password
Warning: The database defined as ‘test’ will be erased and
re-generated from your development database when you run ‘rake’.
Do not set this db to the same as development or production.
test:
adapter: sqlserver
database: buildview_test
host: localhost
username: user
password: password
production:
adapter: sqlserver
database: buildview_rails
host: production
username: user
password: password
============== schema.rb ==================
This file is autogenerated. Instead of editing this file, please use
the
migrations feature of ActiveRecord to incrementally modify your
database,
and
then regenerate this schema definition.
ActiveRecord::Schema.define() do
Could not dump table “SalesCustomers” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “SalesPlans” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “community_news” because of following
ActiveRecord::StatementInvalid
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 community_news
Could not dump table “community_news_users” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “disclaimers” because of following
ActiveRecord::StatementInvalid
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 disclaimers
Could not dump table “home_milestones” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “homes” because of following
ActiveRecord::StatementInvalid
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 homes
Could not dump table “homes_users” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “lots” because of following
ActiveRecord::StatementInvalid
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 lots
Could not dump table “milestone_fixture” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “milestone_masters” because of following
ActiveRecord::StatementInvalid
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 milestone_masters
Could not dump table “permissions” because of following
ActiveRecord::StatementInvalid
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 permissions
Could not dump table “permissions_roles” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “plans” because of following
ActiveRecord::StatementInvalid
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 plans
Could not dump table “roles” because of following
ActiveRecord::StatementInvalid
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 roles
Could not dump table “roles_users” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “sales_lot_status” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “salescancellations” because of following
ActiveRecord::StatementInvalid
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 salescancellations
Could not dump table “salescommunities” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “salesconfigurations” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “salesconstructionstages” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “saleslots” because of following
DBI::DatabaseError
EOF
OLE error code:800A0E78 in ADODB.Recordset
Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
Exception occurred.
Could not dump table “subdivisions” because of following
ActiveRecord::StatementInvalid
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 subdivisions
Could not dump table “user_login_history” because of following
ActiveRecord::StatementInvalid
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 user_login_history
Could not dump table “users” because of following
ActiveRecord::StatementInvalid
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 users
Could not dump table “workflows” because of following
ActiveRecord::StatementInvalid
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 workflows
end
================ end schema.rb =================