This may well be a duplicate, but I couldn't find anyone asking quite this question. My understanding* is that if I want to migrate data from an outside source to my Rails app's database, I should do so using a migration. It seems from my preliminary research that what I could do is use a tool like FasterCSV to parse a CSV file (for exa...
Hi there, does anyone know a way to write a Doctrine migration to change the Table Engine of a MySQL Database from MyISAM to InnoDB? Can this be managed via Migrations or do I have to this the old way via SQL-Statements? ...
Hi I'm migrating a few databases from sql 2000 to sql 2008. while running upgrade advisor I got a message that says that there are objects with the Dump/Load sintax. that is not on use anymore. So I found the following text in a proc Dump DataBase @name to @path With Init Further investigating I discovered that this was a backup and...
I have CoreData-based data layer (using a SQLite datastore) that I am using in both an iOS app and on the server that the iOS clients talk to. The data layer (objc code + coredata model / mapping defns) is compiled into the iOS bundle as per usual, and is compiled into a Framework bundle for use on OSX. I am hitting a brick wall with d...
:datetime and :timestamp in a migration file seems like the same in MySQL and Sqlite3, and they both map to datetime in the database side, except I can't find that in a formal documentation. Also, what about when if our Rails project may use other DBMS, then should we use :datetime or :timestamp when we script/generate (or rails generat...
In Rails 3, I created a table with a migration, then added a column with a migration which creates a has_many, belongs_to relationship.... I then ran rake db:migrate I'd like to now add an Index because I forgot to add it before I can migrate. can I add that to one of the existing migration files (the create table one) or do I need to...
I have a small project which I started in bazaar, as an exercise to learn bzr. I've since decided I prefer Mecurial. How might I migrate this project to Hg? ...
My dev team needs to more precisely run rake tasks. There are certain tasks that need to be only run once after a specific code change. Without getting too specific, it would be like needing to update certain existing users records after a new business rule for new users is implemented in the code. We like how migrations use a db table...
I would like to migrate a project (legacy code which I am not quite familiar with) from Xerces-C v2.x to v3.x. It turns out that Xerces-C v3 dropped the DOMBuilder class. The migration archive tells me this: ...a number of DOM interfaces (DOMBuilder, DOMWriter, DOMInputSource, etc.) were replaced as part of the the final DOM Level 3...
We recently migrated a large ASP. website from framework 1.1 to framework 3.5 and in the process also migrated from a website to a web application. On the surface everything seemed to work fine, but now we are discovering that none of the "pages" are doing what they used to. The site is made up of one default.aspx page that loads all t...
We would like to migrate an application written using EJB2.1 beans (both Entity and Sessions beans) to EJB3 to improve on maintanance and use new features in the EJB3 spec. How would we do the migration and give the users the guarantee (if any) that the migrated system still works just as the old one. The original app didn't have test c...
I am building a visual studio like application: User can create a new project, edit it, save it to disk and load. The project isn't exactly like VS it is domain specific. Like with VS I need a way to migrate project from V1 to V2 as they have a different structure on disk. When should I build such migration tool? option 1: Near the en...
I am in the middle of converting an application that uses swing and awt to draw things to SWT. Since it's sort of overwhelming I'm going through, replacing all references to "awt" to the corresponding swt type. That works for rectangles (only a few methods had to be renamed) but there are some types I don't know how to deal with. If you ...
I'm currently investigating if it makes sense to delay some minor planned refactoring work and combine it with the migration to Java 7, but I'm a little bit concerned that it might make it harder to trace the causes of some bugs if both code and platform change at the same time. The benefit of the move would be the ability to clean up a...
We are using Google Apps Email Migration api to migrate the email content to Apps. But we are facing an issue with email where attachments are more than 2 MB in size. For those items the email are not getting migrated and providing error. As per the below link http://code.google.com/googleapps/domain/email_migration/developers_guide_pro...
Hello, I am about to start migrating sites to a clean install of cpanel. I do not have any backup files from the old hacked server but I do have access to the old harddrive. It is mounted on the new server as a drive. I have found articles such as http://linuxstuffs.wordpress.com/2008/08/31/directory-structure-of-cpanel/ and http:...
I'm trying to run the following migration def self.up add_column :users, :perishable_token, :string User.all.each { |u| u.reset_perishable_token! } change_column :users, :perishable_token, :string, :null => false add_index :users, :perishable_token end and the u.reset_perishable_token! code behaves strangely (no retur...
I'm using Core data in an iOS project. I have the data model setup for automatic data migration whenever I modify entity properties. But I recently made some changes to some entity relationships and now my app crashes with: "Can't find model for source store" I realize that resetting the app i.e deleting and re-installing will solve thi...
This is the best tutorial I found so far on migrating data across apps: http://www.mobileorchard.com/lite-to-paid-iphone-application-data-migrations-with-custom-url-handlers/ But it only discusses the case where you have total control over how the data is represented, such as would be the case if you were constructing your own archivab...
I'm using NetBeans + Rails 2.3.8. I notice that whenever I generate a model, the migration filename for it includes the date and time: Model Name: User Migration File Name : 20100916172053_create_users.rb But when I see books (like Agile Web Development with Rails), the (rake-generated examples int it) all show simple numbers like 0...