search for: db_schema_import

Hi all, I dumped my schema from SQLServer 2000 without any problems. I then tried to "rake db_schema_import" on MySQL 4. To do this i changed my database.yml settings to use the mysql adapter (as it was set to use sqlsever before) and attempted the import. I haven''t changed a thing in the schema.rb script and, even though I do have generated a migration, I think I don''t even ne...

...info into the self.up section in the schema file and made sure there were no obvious problems. So far, so good. I then did a ''gem install mysql'', created a new MySQL database, set up a MySQL user, tweaked database.yml to point to the new MySQL database and tried a ''rake db_schema_import''. Wham! Loads of warnings, ending in an ''uninitialized constant Mysql''. I''ve confirmed that the database.yml file is OK. I then did a ''rake db_schema_import --trace''; here''s what I think is the relevant section of the output: ** In...

...od `string_to_binary'' for ActiveRecord::ConnectionAdapters::ColumnDefinition:Class This happens for me on Windows, Linux, MacOX, ruby 1.8.2/1.8.4, rails 1.0, mySQL 4.1.14. looking at the error, it looks like there might be some sort of bug with a backtick/single-quote mismatch. Migration db_schema_import always fails. Anybody else experiencing this? -- Sean Wolfe master nerd of i heart squares, Co. 3711 N. Ravenswood Ave. #147 Chicago, IL 60613 Ph. (773) 531-6301 Fx. (773) 529-7041 http://www.iheartsquares.com

...20 t.column "description", :text t.column "created_on", :timestamp, :limit => 14 t.column "updated_on", :timestamp, :limit => 14 end end Then, when I try to re-import the same schema, I get a SQL error: mickey@bunny:~/dev/rails/timeonrails$ rake db_schema_import (in /home/mickey/dev/rails/timeonrails) rake aborted! Mysql::Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''(14), `updated_on` datetime(14)) ENGINE=InnoDB'' at line 1: CREATE TABLE categ...

Hello, I am trying to put my rails app on a host .So I presume the method to do this is to first do rake db_schema_dump and then copy it to the host and do rake db_schema_import. I use mySQL Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 4.3 ** Invoke db_schema_import (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db_schema_import rake aborted! Mysql::Error: You have an error in your SQL syntax; check the manual that...

Hi, I have a mysql schema with some decimal(20,20) fields. Now, I made a rake db_schema_dump for deployment of my applications on other machines. Rails created a schema.rb with the decimal fields as float. After a rake db_schema_import the fields are just float not decimal. How can I force rails to create decimal(20,20) columns instead of float? Thx. Marc -- Posted via http://www.ruby-forum.com/.

hi, is there a way to create the database (say development and or production) specified in database.yml with rake? thanks, Enrico -- "The only thing necessary for the triumph of evil is for good men to do nothing" Edmund Burke

...lse rails changes it to this in the schema: t.column "data", :binary, :default => "", :null => false not only is this not what I wanted because it removes the size restrictions it also blows up when you try to do rake db_import_schema with this error: site_path>rake db_schema_import (in D:/sites/itsthes/itsthes-ruby/itsthes) rake aborted! undefined method `string_to_binary'' for ActiveRecord::ConnectionAdapters::ColumnDefinition:Class Is anyone else know why this is happening? Does anyone else have a problem with rails converting values in the schema.rb to something...

I tried to use ''rake db_schema_dump'' from old MySQL database and then use ''rake db_schema_import'' to rebuild the database in PostgreSQL. The issue here is that only some of tables can be imported successfully. For example, in the dumped schema.rb: create_table "profiles", :force => true do |t| t.column "ticker", :string, :limit => 10, :default => &q...

...iguration does not specify adapter $ rake clone_structure_to_test (in /Users/jkh/Development/assetstream) rake aborted! You have a nil object when you didn''t expect it! You might have expected an instance of Array. The error occured while evaluating nil.[] Strangely, db_schema_export and db_schema_import work just fine. And my application runs fine. I am using MySQL, and it is configured correctly in database.yml. To make sure it wasn''t a syntax error, I copied database.yml to a fresh rails project and it works fine. There is something else in my project that is quirked, and causing the er...

Hi, I''d like to use migrations to build my initial database. Is there a gem or plugin that will generate the migration code for initial db if I point it at a live database or sql file? If yes, then can you automatically generate the incremental migrations as well? Thanks, Jason

...rake.rb:455:in `[]'' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `run'' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `run'' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/bin/rake:7 c:/ruby/bin/rake.bat:25 """ I tried doing rake db_schema_import, as well, but it only included the migrations I had defined for my project and not the login_engine''s migrations. Any help would be greatly appreciated. Regards, Ryan Mulligan

Is there any tools for migrating data from old database to a new database to be used by rails? Thanks in advance. http://www.ProblemSolvingSkill.net Hone your problem-solving skills

...z 02/21/06 #3517 [PATCH] allowing url_for to work with just created controller - great for actionmailer tests ActionPack nseckar@gmail.com 01/17/06 #3501 "sprint" used as a possible enum value causes problems associated attribute ActiveRecord michael@koziarski.com 01/16/06 #3101 rake db_schema_import broken ActiveRecord rails@bitsweat.net 12/04/05 #2993 rc5 crashing FF1.5rc3 script.aculo.us sam@conio.net 11/23/05 Final Drive Candidates (what MIGHT be added to Next Final Drive. 1 ticket) http://dev.rubyonrails.org/report/19 Potential 1.1 Blockers (unofficial list. 169 tickets. please help ve...

...ation file 3. rake migrate 4. if more modifications required then rake migrate VERSION=0 goto step 2 5. rake db_schema_dump 6. checkin The next change basically goes through the same steps. To create a fresh database without going through all the migrations: 1. checkout from SVN 2. rake db_schema_import Now here come the questions: a. Any comments on the procedure described above? b. Where do I define the initial data? E.g. the statusses in a status table. In http://wiki.rubyonrails.org/rails/pages/UnderstandingMigrations it is suggested to put these in a migration script. But these lines ar...

I''ve got a bunch of table creations in the schema.rb file and all is well. However, I have to manually go and create the db first. Is there a way (something like a create_database method) to get this to work? (execute "create database ..." didn''t seem to cut it either.) _______________________ Brad Eck Sr. Software Engineer Pelco 3500 Pelco Way Clovis, CA 93612

On a rails app that I''m developing I converted a regular old .sql file into a rails migration. Since I generated the migration in my development environment, it created the schema_info table for me. However, when I updated my production environment and tried running rake migrate it complained that schema_info doesn''t exist. Is there a rake task for getting around this yet, or

I have a fully developed e-commerce site with ruby on rails. it is in sandbox mode with paypal and I want to make it live. unfortunately my developer''s time on the project is up. i have the instructions to make it live, but im not familiar with rails (YET!). I intend to be, but I''d really like to get this live. Can a trusted rails developer on this site do this simple thing

Hallo -- could anyone tell me how I use Migrations (which my existing development schema is implemented with) to create the production database for deployment? The target DB is a SQL Server database -- I don''t know if that''s an issue -- I seem to remember reading that SQL Server is supported now. Oh, yeah -- SQL Server was *not* my choice! But what I seem totally unable to

Recently I''ve wanted to be able to take the data I''ve painstakingly defined in my fixture files and slurp it up into my development database so I can play with my website (locally, in development mode) with the same data I use in my tests. In a similar vein, I want to take the table definitions in the development_structure.sql file and use it to re-define my development