similar to: problems using Migrations

Hi A newb question. Can I use migrations if all of the following requirements are imposed at the same time. 1. Copy data from an old schema to a new schema, the difference in the 2 schemas is about 25%, 3 new tables and 4 new columns. 2. Copy data from Oracle schema to DB2 schema, around 25% difference in 2 schemas as above. 3. Neither old nor the new schema tables have an

Hi All I am trying to understand if I can use migrations to migrate data under the following conditions 1. Across 2 different databases (Oracle/DB2) with same schemas. 2. Across 2 different databases (Oracle/DB2) with different schemas. I am trying to avoid writing DBI/OCI8 scripts. Can somone please shed some light if this is even possible? thanks -daya -------------- next part

Hi All Please excuse me if my questions sound silly. I have developed a rails app with an existing legacy schema and now with changes in customer requirements, I need to change the schema. The legacy (schema) database has > 250K. What I would like to know is 1. Is it possible to migrate the data along with migrating the schema if use Migrations? If it is possible can somebody point me to an

I have a DB2 schema with many ''views'' and table partitions defined in it. As per our new project requirement we have to support multiple databases (DB2,Oracle and MYSQL to be specific). The frontend application is implemented using Ruby on Rails. I am interested in exploring the possibility of using Rails Migrations to abstract out the schema to a DB independent layer. I could

Hi All I am running a mongrel on win2k and I don''t get any log output I have tried to these two options 1. Stream redirection using "mongrel_rails start -c C:/myspace/snapshot -p 4111 -t 70 -e production -P log/mongrel-1.pid > C:\temp\mongrel- 1.log" The console print the output stream and the mongrel-1.log file shows no content except the content generated after I kill

Hi All I am new the RoR and would like some advice on how to integrate SiteMinder authentication/authorization in my Rails app. For those who are not aware SiteMinder authenticates users and then redirects the user back to the application that requested authentication while setting response header which look something like this

Hi, I am trying to use sqlSave to write a dataframe to an existing table in a DB2 database. The database contains two schemas. My experience is the following: (1) in the case that tablename is left empty in sqlSave, R writes to the instance level schema (2) in the case that a tablename is specified and that table name exists only once in the database, R will write to that table irrespective

Hi, I''ve an applicattion actually in production wich i wrote in php last year. Now, I''m working on a new version in Ruby/Rails. So, can someone tell me how can I generate a migration so that every time I run it the "data" from the old db get''s copied to the new one?? Note that _I''ve already the schema, I want something that automatically could

Hello, As a rails newbie, i have stumbled upon some tutorials promoting migratons. I have thought, wow, cool and started using them right away. However, now that i am reading the RoR list on a daily basis, i have seen also mails ranging from ''migrations are not always the best'' to ''migrations are evil'' and even ''i would not use migrations even

Hi there, Does anyone know when, or if, the DB2 connector will support migrations? Thanks, --Jim

Hi All Just a few minutes back I came across a post about autotest/zentest and that post reignited the feeling I get when I look at RDoc, RoR documentation. The main thing that is lacking in RoR and to some extent Ruby''s RDoc is showing method names in HTML is not documentation. The arguments to method, exception/errors raised by method, return value and a usage example completes the

Hi Is anyone aware of any Document Management System in Rails. Googling didn''t help me find any Rails based solution. The DMS I need, need to have the following feature apart form the usual ones. 1. Version control of documents. 2. Tracking version control for each group of users independently from the other group . These groups may share the same document name but may have different

Testing - Do my emails reach rails mailing list? -daya -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060808/cb3e29ba/attachment.html

Hi All I am using version 0.3.13.3 and since there is no logging support for win32 application. I was wondering if it was possible to get any kind of logging at all. I have tried to these two options 1. Stream redirection using "mongrel_rails start -c C:/myspace/snapshot -p 4111 -t 70 -e production -P log/mongrel-1.pid > C:\temp\mongrel-1.log" The console print the output stream

Hi, Suppose I want to redefine the Ruby String class in a Rails app. In which file is it the most suitable to write the redefinition? Thanks Guillaume Carbonneau -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060816/5b0da204/attachment.html

Hi All I am trying to implement a functionality where a user clicks on "Back to Search Results" link he is taken to the search result screen. For this I am storing his search criteria (params object) in session. Here is my code ______________________________________________________________________________________________________________ *def* search

Hi All I was just wondering why my posts don''t have [RAILS] prefix in the subject line unless I specify one. Can that be a reason why I don''t receive replies to my posts? or atleast not as much as others :( -daya -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hello, I have an SQL file that I want to import in a migration. It is data that will never change and must always be in the database for the application (if you must know, it is a database of about 140,000 cities in the U.S.). Originally, I did this: cd ~/app mysql -u root source db/migrate/initial.db So then I thought this would work in my migration: def self.up execute ''source

Hi Another newbe here..... I was wondering if someone could please help me understand the controllers/view inner working in Production 1. If xxx_controller.rb is only loaded once does it mean there is only one instance of Controller serving all requests? 2. If only one instance of controller is there then how are controllers instance variables protected from data corruption when serving multiple

I am running R version 2.8.1 on Windows XP OS. This works fine. (Data.frame dta is created with records from the DB2 table.): sql <- "select * from storage.testappend_slt order by uut" dta <- sqlQuery(channel,sql) But when I try to append records (from data.frame newdta) to the same DB2 table. I get an error: sqlSave(channel, newdta, tablename = storage.testappend_slt, append