similar to: rake db_schema_dump: Dump the data too?

Anyone know why "rake db_schema_dump" would produce the following error: rake aborted! Don''t know how to build task ''db_schema_dump'' (See full trace by running task with --trace) Otherwise, my migrations work fine. -- Posted via http://www.ruby-forum.com/.

rake migrate bug with datetime: > rake db_schema_dump produced a bad schema.rb that isn''t valid ruby, it has an invalid default, unless ruby takes bare words: t.column "date_available", :datetime, :default => Sun Jan 01 00:00:00 Arabic Standard Time 2006, :null => false I don''t think the Baghdad time zone should matter. ruby 1.8.4, rails 1.1.2,

Oh noes! What do I do? Just installed RoR and SQLite3 yesterday, watched a screencast that said the db_schema_dump will slaughter my enemies and make my poop smell like rainbows. Now I get rake telling me that it doesn''t know how to. Any help? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are

Hi all I''m just learning to use rake and ran into the following problem: chraftbuech:/Users/Josh/Webwork/CommentingSystem josh$ rake create_test_news (in /Users/Josh/Webwork/CommentingSystem) Create test news rake aborted! ActiveRecord::ConnectionNotEstablished The task''s code is: desc ''Creates some test news items with comments'' task

We''re using migrations to manage a SQL Server project and have been running into a number of issues with db_schema_dump/migrations. Can anyone confirm that these are actual issues with the SQL Server adapter and not issues with me :) 1) Fields are not properly setup with proper null settings (:null => true / false). I''m wondering if we need to update the def columns method

I know I can get the schema by running rake db_schema_dump but, is there a way to ge the data from a table or a database into a format that can be quickly converted to a migration. What I''m really trying to do is synch my local development database (schema and data) with the db on my hosting service. -- Best Regards, -Larry "Work, work, work...there is no satisfactory

Hi all I want to add some rake tasks to my app using a plugin. So I added some tasks to vendor/plugins/my-plugin/Rakefile, but it seems that the tasks in a plugin''s Rakefile are not available to access from the application root, but you have to change directory to vendor/plugins/my-plugin. Is that correct? I''d really like to make my rake tasks from the plugin accessible by the

I''m somewhat of a newbie - played with recent versions of rails a few mths ago, but have decided to start from scratch with 1.0. I want to build my new db as much as possible with migrations, so I watched DHH''s migrations movie from rubyonrails.org. A few things confuse me: 1. He generates the model ("post") before running rake db_schema_dump. Is that necessary or

Hi, I dumped the schema using rake db_schema_dump. Now how do I create a migration containing all the data I have in my dev db ? -- Jean-Christophe Michel

Just wondering if there''s a way to use migrations to generate join tables (where the table columns comprise only of foreign keys to other tables, and where the primary key is all the foreign keys taken together). I made the changes manually in MySQL, then did rake db_schema_dump and it gave something like this: create_table "apples_oranges", :id => false, :force

Hi all I''m trying to create a rake task for the first time, so please be a bit patient with me. ;-) I''m coding a photo gallery. Every photo gallery''s photos are in its own folder, and after an update I''d like to be able to synchronize the photo files with the database (because every photo has its own Photo class object). I''ve got so far: # File

Hi, I''m trying to get my head around using migrations to define my initial schema. When using migrations, I want to: - Avoid creating a new migration for every small change. Limit it to one migration per checkin. - When creating a new (fresh) schema, I do not want to go through the overhead of all the migrations. These are the steps I came up with, to create the initial schema: 1.

Subject says it all: rake doesn''t know about db:fixtures:dump. When I try, I get this: Don''t know how to build task ''db:fixtures:dump'' I thought this was a standard feature that ships with rake- any idea why it''s missing, and how I can reinstall it? Here''s the environment: Ruby version 1.8.4 (powerpc-darwin8.6.0) RubyGems

Hi all According to the Agile 2nd Ed book I added the line encoding: utf8 to my database.yml connections. But now when running rake I get plenty of errors: Character set ''utf-8'' is not a compiled character set and is not specified in the ''/usr/local/mysql/share/mysql/charsets/Index'' file What''s wrong here? I checked this Index file, but it seems to

I have a dump of some tables to be filled when the app is setup ''.../db/dataset/regions_dpt_cities_codes.sql'' I would like to execute a task similar to the >mysql source <dump_file> like : ActiveRecord::Base.connection.execute("source #{path};") (which doesn''t run fine, of course.... is it possible in a rake task ? if yes, any suggestion ?

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

Filed a ticket for bogus Ruby produced via: rake db_schema_dump http://dev.rubyonrails.org/ticket/3232 I''d appreciate it if someone could verify against PostgreSQL 8.0.x -- -- Tom Mornini

Hi all I''m trying to get GetText to work. I have the following folder structure: |-myapp.pot |-de_DE/: | `-myapp.po |-en_GB/: | `-myapp.po |-en_US/: ` `-myapp.po I run rake updatepo, and then rake makemo. Now I set en-gb as default language in Firefox and run my app >> works! Then I set en-us as default language in Firefox and run my app >> works,

I recently submitted ticket #9240 (1) adding Oracle support for the rake db:reset task. I don''t consider myself an Oracle expert by any means, and would appreciate if someone familiar with the database can take a look and verify that I''m going in the right direction. Thanks. 1. http://dev.rubyonrails.org/ticket/9240 -- Josh Knowles joshknowles@gmail.com

Is anyone using migrations with a SQL Server database who might be able to lend me a hand? I''ve used migrations with MySql in the past and haven''t run into any issues so forgive When I run rake migrate nothing is actually getting updated in my database. I created a migration using ./script/generate migration AddFooTable and updated the migration to look as follows: class