similar to: Schema.rb and MySQL decimal

Hello everyone, I''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

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

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

I have not been able to get DB migrations to work at all in Rails 1.0 for me. On multiple platforms I continually get the same errors. It took me awhile to figure out some initial things, such as Migrations don''t seem to support Enum column types, and doesn''t really support Foreign key relationships (the constraints at least). After changing my DB schema to jive more with the

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

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

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.

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

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

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

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

Hi, This post concerns a SQL error while I try to import a schema into MySQL with timestamp dates. To reproduce try these commands: mickey@bunny:~/dev/rails/timeonrails$ rake db_schema_dump (in /home/mickey/dev/rails/timeonrails) mickey@bunny:~/dev/rails/timeonrails$ cat db/schema.rb # This file is autogenerated. Instead of editing this file, please use the # migrations feature of ActiveRecord

I have a mysql database that I am trying to use migrations on. The problem that I am having is that when I create a blob field in my migration file like so: t.column "data", :binary, :limit => 15.megabytes, :null => false rails changes it to this in the schema: t.column "data", :binary, :default => "", :null => false not only is this not what I wanted

Hello, everyone. I have an application that began on a much earlier version of rails, and has been upgraded to 1.0. Somewhere along the line, tests got broken. The first thing I noticed, upon looking into the cause, is that my test database was not being cloned correctly from development. So, I tried to run the tasks by hand: $ rake clone_schema_to_test (in /Users/jkh/Development/assetstream)

Hello, I have been having problems installing the Login Engine. I follow all the steps found on the download site (rails-engines.org), but when I get to the DB_SCHEMA step, I do rake engine_migrate ENGINE=login in the application root. """ C:\rails\cag> rake engine_migrate ENGINE=login (in C:/rails/cag) rake aborted! Don''t know how to build task

Hello! In the book Modern Applied Statistics with S (4th ed), section 5.6 the concept of the "average shifted histogram" or ASH is mentionend. Also it is mentioned in the same section "The code used is in the scripts for this chapter" (from figure caption 5.8, analysis of the geyser duration data). *However*, I have trouble finding the code for that function! Admittedly, I am a

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

Has anyone accomplished storing settings that would normally go in environment.rb into the database? For instance, I''d like it if I could specify my ActionMailer properties from a web UI admin panel ActionMailer::Base.server_settings = { :address => "mail.server.here", :port => 25, :domain => "somewhere.com", :authentication => :login,

Dear all: When I have more variables than units, say a 195*10896 matrix which has 10896 variables and 195 samples. prcomp will give only 195 principal components. I checked in the help, but there is no explanation that why this happen. Can we get more than 195 PCs for this case? Thank you very much. Best! Alan Aug-12-2005