search for: db_schema_dump

...s 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 just a preference? 2. He says that running db_schema_dump will create not only the schema file, but the database. He''s using sqllite, I''m using MySQL, and it didnt work for me. That is, rake db_schema_dump issued an error complaining that the database di...

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 sho...

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/.

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 in activerecord/lib/activer...

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 subscribed to the Goo...

Hi all I''d like to dump also my data with rake db_schema_dump. Is there a way to do this? Thanks Josh -- Posted via http://www.ruby-forum.com/.

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

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

...ment.rb file: ActiveRecord:: Base.connection.instance_variable_get("@connection")["AutoCommit"] = false The trace when I run rake migrate --trace is as follows: ** Invoke migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute migrate ** Invoke db_schema_dump (first_time) ** Invoke environment ** Execute db_schema_dump The following SQL is executed: Audit Login -- network protocol: TCP/IP set quoted_identifier on set implicit_transactions off set cursor_close_on_commit off set ansi_warnings on set ansi_padding on set ansi_nulls on set concat_null_y...

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...

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

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 |...

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 => true do |t| t.column "apple_id", :integer, :limit => 10, :null => false t.column "orange_id", :integer, :limit => 10, :default => 0, :null =>...

Hi, I''m using the ''rake db_schema_dump'' command to clone the structure of the developement database into the test database. Unfortunatelly, the schema.rb file doesn''t contain any information about the foreign keys of the tables. For this reason all the test that concern about the relations are not working has supos...

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, w...

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

I''ve poked around a bit with Google and I can''t find a way to generate a base set of migrations from a given SQL schema. Is there an easy way to do this? thanks John

...9;m trying to migrate a working app from Postgres to MySQL, and I''m trying to use a migration to get it done rather than alter all my database table creation scripts to MySQL syntax. I''ve done loads of work with Postgres, but am a real newbie with MySQL... I did a ''rake db_schema_dump'' from my Postgres app, and got a nice looking schema file with all my tables and fields, exactly as expected. I then created a migration file, pasted the schema 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 &...

Hey guys, I was playing around with the command "rake db_schema_dump" and kept getting this error "no such file or directory - /tmp/mysql.sock". I tried looking around to find this mysql.sock file; but no luck so far. Question: What is mysql.sock file? (how does it get created and how does it get used) I installed a MySQL DB and could not find thi...

Has anybody heard of / written a tool/generator that quickly converts any SQL DDL into migration create_tabl tasks. i know i could just go the way of creating the tables and then do a rake db_schema_dump, but since this is something i do continuously i would like to find a quicker route. Thanks Sebastian