Details
Description
Email from gommo :
I can't get Sonar to update our 1.2.1 MsSQL sonar database to 1.3
This is the error I get
2008.06.26 13:40:30 ERROR rails.sonarActiveRecord::StatementInvalid (ActiveRecord::ActiveRecordError: Table
INFORMATION_SCHEMA. does not exist: SELECT CONSTRAINT_NAME FROM
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where TABLE_NAME = 'projects' and
COLUMN_NAME = 'group_id'):E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/connection_adapters/abstract_adapter.rb:128:in
`log'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.8/lib/active_record/connection_adapters/jdbc_adapter.rb:520:in
`execute'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.8/lib/active_record/connection_adapters/jdbc_adapter.rb:580:in
`select'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.8/lib/jdbc_adapter/jdbc_mssql.rb:253:in
`remove_check_constraints'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.8/lib/jdbc_adapter/jdbc_mssql.rb:239:in
`remove_column'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:275:in
`method_missing'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:259:in
`say_with_time'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:259:in
`say_with_time'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:273:in
`method_missing'E:/BuildServer/sonar-1.3/war/sonar-web/app/controllers/../../db/migrate/035_projects_to_entities.rb:48:in
`up'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:212:in
`migrate'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:212:in
`migrate'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:335:in
`migrate'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:330:in
`each'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:330:in
`migrate'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:297:in
`up'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/migration.rb:288:in
`migrate'E:/BuildServer/sonar-1.3/war/sonar-web/app/controllers/setup_controller.rb:48:in
`setup_database'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/base.rb:1101:in
`perform_action'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/filters.rb:696:in
`call_filters'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/filters.rb:688:in
`perform_action_with_filters'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in
`perform_action_with_benchmark'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in
`perform_action_with_benchmark'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/rescue.rb:83:in
`perform_action_with_rescue'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/base.rb:435:in
`process'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/filters.rb:684:in
`process_with_filters'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/session_management.rb:114:in
`process_with_session_management_support'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/actionpack-1.13.6/lib/action_controller/base.rb:334:in
`process'E:/BuildServer/sonar-1.3/war/sonar-web/WEB-INF/gems/gems/rails-1.2.6/lib/dispatcher.rb:41:in
`dispatch'I also tried with a blank database and it failed as well.
Is it known to work on SQL Server 2005