similar to: Migrations: execute() and importing SQL files

Hi All I am trying to figure out if I can use migratons when the following requirements are imposed at the same time. 1. Migrating 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. Migrating data from Oracle schema to DB2 schema, around 25% difference in 2 schemas as above. 3. Neither old nor the new schema tables have a

Hello, I created a table and about 10 migrations down the line I decided that I needed to add an ID column (this was actually a table for a has_many :through and I recently realized that it needs an ID column, unlike HABTM tables). I am a big perfectionist and I frequently run "SHOW COLUMNS IN table;", so I naturally expect to see the "id" column the first one listed. However,

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

Anyone here able to generate the DDL SQL for performing migrations w/ out actually modifying the DB schema? As part of our process, we''d like to be able to write the migrations and produce the DDL and then have our data services folks verify and make changes according to naming conventions, etc. Aside from grabbing the SQL migration log following a "live" migration - I

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

Hello. I realize that link_to is a helper that generally only has use in a view file, but recently I have come across a situation where it would be useful in a controller. I am trying to create a flash[:notice] and I want to link to another page. Of course, I could hard code the HTML, but for the sake of consistency, I was wondering if there is a way to abstract it from within the controller

Hi all. I keep having the following error when I invoke the rake db:migrate command for Rails 1.1 (Ruby 1.8.2 -- Windows 2000) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate == Realtorex: migrating ======================================================= -- create() rake aborted! undefined method `create'' for

After adding Migrations to my Rails app (they seem terrifc) when I run, say, ruby script/generate scaffold City I am getting a dependency model error "Another migration is already named add_cities: db/migrate/001_add_cities.rb" Model City is already in my app and when I run this scaffold generator I''m not intending to be touching any of the migration stuff. What causing this

Christian Thanks for the information. Also thanks to mj. That's sounds promising How did you migrate your data? Did you need to add any schema to samba4 ad? Were in 5 cities and some of the Internet is not 100% reliable. Will need samba4 in each office to make sure they can log in even if the Internet is down. How reliable is the the ad syncing? Does it need a lot of bandwidth? One of the

All, I''ve decided to jump into Migrations before I get too far along on the DB side of things. I already have some tables built, and I went ahead and built the migration that would have created them from scratch, and I made sure that there was a self.down section to drop them. I wanted to verify that I could roll back so I figured I would use rake to drop these pre-existing tables

I have an array @dpt_ids ex : @dpt_ids = ["43", "48", "49", "50", "51"] I try to insert it into my sql query to be used in a ''find_by_sql'' query = "SELECT * , #{kms} AS km FROM cities" query << " WHERE department_id IN ( #{dpt_ids} ) " but this transform my array into a unique string :

Hi Friends, I am trying to import a table from SQL server to R(2.9.0), however i am getting errors while running the below codes. Can anyone identify and let me know where did i go wrong??? Thanks in anticipation :) library(RODBC) myconn <- odbcConnect("RDATABASE") myconn RODB Connection 6 Details: case=nochange DSN=RDATABASE Description=Database for R UID=Madana_Babu

Hi there, I am trying to deploy a rails app on dreamhost. Here is the error message that I get: fatal: ''home/USER_NAME/DOMAIN_NAME/git/APPLICATION_NAME.git'': unable to chdir or not a git archive fatal: The remote end hung up unexpectedly /Users/USER/.gem/ruby/1.8/gems/capistrano-2.5.3/lib/capistrano/recipes/ deploy/scm/git.rb:224:in `query_revision'': Unable to resolve

Hum..if the live migration is not happening on a shared storage, then I think it is best to have offline migration copy to image and hook up to the destinated server instead, this is a short-cut path I suppose. Xlord -----Original Message----- From: CentOS-virt [mailto:centos-virt-bounces at centos.org] On Behalf Of Valentin Guggiana Sent: Monday, March 20, 2017 8:47 PM To: Discussion about the

I am using R 2.1.1 in a Windows Xp environment. I need to import a large database from Microsoft SQL into R. I am currently using the ?sqlQuery? function/command. This works, but I sometimes run out of memory if my database is too big, or it take quite a long time for the data to import into R. Is there a better way to bring a large SQL database into R? IS there an efficient way to convert

Rails 3.1 RC4 has broken migrations $ jruby -v jruby 1.6.2 (ruby-1.8.7-p330) (2011-05-23 e2ea975) (Java HotSpot(TM) 64-Bit Server VM 1.6.0_24) [darwin-x86_64-java] $ jruby -S rails -v Rails 3.1.0.rc4 $ jruby -S rails new myapp -d jdbcpostgresql [...] $jruby -S rake db:create [...] $ jruby -S rails g model user name:string invoke active_record create

Hello all, I''m trying to initialize my migrations against a current database implementation. rake db:schema:dump runs without error. The resulting schema.rb is pasted below, along with my database.yml Can one of you point me in the direction of enlightenment? -- ------------------------------ Apple MacBook. Black. It''s the new White! ------------------------------ Peter

Sybase Presents "Linux and Replication: Reducing Cost and Risk in Migrations" Date: Tuesday, November 18, 2003 Time: 10:00 a.m. PST/1:00 p.m. EST Duration: One hour Linux. Low cost platform. High performance. So, the question with Linux is no longer "why", but "how". During this Web Seminar, you'll learn how to use replication to successfully migrate to Linux.

Hi, I am doing my first steps with RoR and I have the following problem: I execute my migration file with the following content on a MySQL-database via Rake: <code> class CreateUsers < ActiveRecord::Migration def self.up create_table :users do |t| t.integer :id t.string :username, :size => 100 t.string :password, :size => 100 t.string :email, :size

Dear Xlord > Please check if the VM guest has vm-tools installed else the ?virsh > migrate --live? parameter requirement is not fulfilled else you has to > turn off the VM guest and do the offline ?virsh migrate? without > ?--live? options. Hope that helps. As far as I know (and it definitely worked in CentOS 6 and from CentOS 6 to CentOS 7) no guest tools are needed. But I tried it