Hello all i look around for software to MySQL Migration som bardy maby can help me? i use OSX platform, and relly confurse over i can't get a software for this. i use a lot of time to look 2 database its "up2date" sombardy can maby help? or maby MySQL scripting i need? donno i hob for helping to mysql Migration software on osx. ...
I tried creating a DB migration in Rails that looked something like this: ruby script/generate scaffold post user_id:int title:string content:text Looking at the resulting .rb file, sure enough, I saw everything I'd entered: class CreatePosts < ActiveRecord::Migration def self.up create_table :posts do |t| t.int :user_id...
Hi all, I am preferring to manually migrate my tables in Django. Because using automated tools puts me in a place where I cannot see the impact. With impact, I mean the the time it takes the db get in synch with my models. Below is a simple example: class User(models.Model): first_name = CharField(..) Let's say I want to add this:...
Hi all, I currently use Authlogic in a web-app to handle user authentication, but have now decided to create a limited API which would seem to require the use of a single_access_token. My question is, how can I apply the migration to existing users? I thought using something like add_column :users, :single_access_token, :string User....
Hi, Is there a way where I can transfer a ASP.Net application completely to a new system? I have copied the project directory before and it usually works, but I have issues with "References". I'm trying to take over a project from a person and he gave me all the files ( including the .sln files ), but I've got a bunch of reference erro...
I used the MySQL Migration Toolkit to migrate a SQL Server 2008 database to MySQL. However, it converted all my bit types to tinyint. My data model doesn't like this, because I have a bunch of expressions testing for true/false, and not 0-255. Is there a way to tell the Toolkit to convert these different, or some SQL I can run on the ne...
This is a fairly common refactoring, Martin Fowler calls it 'move field'. Given 3 models: class Person < ActiveRecord::Base has_one :contact_details has_one :address end class ContactDetails < ActiveRecord::Base end class Address < ActiveRecord::Base end how do I refactor, including migration, the has_one address from Person to ...
I know this is a frequently asked question, however none of the solutions that I have found seem to work for me. This is my situation: I have one data model for my application, and I wanted to add versioning to it. So in XCode, I did Design -> Data Model -> Add Model Version. I also updated my delegate's persistentStoreCoordinator metho...
Hi, I am not able to create database columns when i use t.string or t.number. When i did rake db:migrate i got this C:\Ruby\joker\chapter3>rake db:migrate (in C:/Ruby/joker/chapter3) == CreateComicBooks: migrating =============================================== -- create_table(:comic_books) -> 0.0630s == CreateComicBooks: migrate...
I just created a simple migration to an existing project. This project uses RMagick, and when I call rake db:migrate the migration fails thus: Dans-iMac-335:myserver apple$ rake db:migrate (in /Users/apple/Documents/projects/electionjoy/glowing-mist-78) dlopen(/Users/apple/.gem/ruby/1.8/gems/rmagick-2.12.1/lib/RMagick2.bundle, 9): Libra...
What resources are out there (free or paid) that help walk you through the process of migrating a Ruby on Rails 2 application to Rails 3? I've seen some blog posts (some of which seem out of date) and an eBook for sale somewhere on the RoR website, but what can you recommend as an accurate and complete explanation of what changed from ve...
Hi, I am trying to convert from MS SQL Server 2008 Express to DB2 9.7. I have installed IBM Migration Toolkit and successfully connected to my SQL Server database (hosted locally). I tried to extract from database, keeping all default data mappings, but when I extract, I get the following (for all tables) - anyone had a problem like...
I have an iPhone app that is using CoreData. I recently made some minor changes to the data model and now every time the app is opened I get an error "Can't find model for source store". I have 2 version of the data model and the only changes I've made were some additions of some fields. I was following the guide here which worked initi...
If no need to migrate the data, it seems that we can just edit database.yml development: adapter: mysql database: myapp_development host: localhost username: root password: encoding: utf8 1) to use a brand new db with 0 data, just change the 3rd line to: database: myapp_development_02 and then do a rake db:create and ra...
After migration, one of my numerical values that should be non-zero now appears as zero. If I don't migrate, the value retains its non-zero value. I first tried to set a number value in a managed object like this: [temp setNumUses:temp.numUses+1]; ... but that caused an'EXC_BAD_ACCESS' so I changed it to: int hold = ((int)[[temp val...
If I change the type of a field in my database via a Ruby on Rails migration, from string to text, will I lose the data in the field? ...
Im creating a simple Rails 2.3.8 gem and need a migration file inside it. I following this structure: / /generators /generators/conductor_migration /generators/conductor_migration/conductor_migration_generator.rb /generators/conductor_migration/templates /generators/conductor_migration/templates/conductor_migration.rb but when I inst...
python manage.py dumpdata modelName > file.json. created an empty database for a user meder on postgres modified pga_hb.conf so that meder can use the database changed the settings in settings.py python manage.py syncdb ( I didnt create a su ) attempting to loaddata file.json but it complains that the superuser isn't there or doesn't m...
I have a sql file that creates a database in mysql: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL'; CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ; USE `mydb`...
Does rake db:schema:dump recreate schema.rb from migrations or the database itself? thanks ...