migration

How to create sequential number column index on table with data

Hi I have the following table with 10 unique rows, BookingID is a FK containing a random number. The number doesn't need to be in sequence. BookingID, Description 1000 Foo 3000 Bar 1500 Zoo I need to insert an sequential index called ID which goes from 1..x how do I do that in SQL Server 2005? I was thinking to wri...

Should I joint-index an ActiveRecord polymorphic association?

I have a metric table that I expect to be very large. It has a polymorphic association so that it can belongs_to other models that want to record some metric. I typically index association columns like this to speed up association loading. I've heard people talking about joint-indexing this association. This looks like: add_index :c...

Problems after Qooxdoo migration to 1.3-pre

I checked out the latest SVN trunk of qooxdoo and now i have the following problems: Some events seems that they are not comming through Virtual Lists are not filled anymore (the _createWidget() method of the extension from qx.ui.virtual.cell.AbstractWidget is not called) My original version was QX 1.0.1-pre and the problems appeared...

Migrating Django fixtures?

I have a Django application. I have .json fixture files containing test data, with unit tests that use the data to confirm the application is working properly. I also use South to migrate my database. After doing a few database migrations, my fixtures are out of date, because the database has migrated, adding a new database column, ...

Rails 3 Rake Clone Database for Testing Environment

Is there a rake command in Rails 3 to clone my development database data? I noticed rake db:test:prepare and rake db:test:clone are mentioned throughout various blogs, but running them seems to do nothing. Furthermore, rake -T shows no db:test cases. I've resorted to loading a sql dump for now, but it would be great if I could just clone...

What are all the steps should be taken while shifting a core data programs location?

Hi friends, I did a program using core data and saved it in my desktop. The entities, relationships are available in .xcdatamodel file. Then i copied my entire program into some other folder in disk and erased the original file placed in desktop. Now the copied program did not work. The managed objects are null. What changes must i do ...

heroku not updating database schema

Hello, Heroku doesn't seem to update my database schema when I deploy. Here are the details: Here is what is should look like for the User class: create_table "users", :force => true do |t| t.string "username" t.datetime "created_at" t.datetime "updated_at" t.string "email" t.string "encrypted_password" t.string "salt" t.strin...

How do I list and fetch remote branches after SVN to Git migration?

I migrated our SVN repository to Git and pushed it to a central repository. We had a fair amount of tags and branches, but somehow we were not able to list and fetch those from a Git client. This was weird, because the tags and branches seemed to be available on the server. With help from a Jon Maddox blog post, a blog post from Marc...

How do :default => 0 and :null => false differ for integer fields in migrations?

If I use a migration to update a database, and I add an integer field like this: t.integer :foo :default => 0, :null => false What is the default state of existing and new records in the database? I hoping the answer is: - Both will read back foo as 0. Is default => 0 necessary, if I have :null => false? Just trying to understand t...

Removing duplicate db migrations from git repository

I'm trying to deploy a rails app to Heroku and I'm running into some basic git problems. I'm new to this all -- rails, git, heroku -- so I'm afraid I'm getting lost on what's probably a fairly basic concept. I've pushed the app to Heroku, but when I'm migrating the db ($ heroku rake db:migrate), I keep getting the following error: rake...

Rails DB Migration - How To Drop a Table?

I added a table that I thought I was going to need, but now no longer plan on using it. How should I remove that table? I've already ran migrations, so the table is in my database. I figure rails generate migration should be able to handle this, but I haven't figured out how yet. I've tried rails generate migration drop_tablename, but ...

Migrating and Backing up Schemas (complex database structures)

Hey guys, I need to figure out a way to back up and also migrate our Oracle database from our production schema to the dev schema and the other way around. We have bunch of config tables that drive how systems on our platform run, and when setting up new systems or doing maintenance, we need to update our config tables. We want to be ab...

Adding South to Django project, development & production

Adding South to an existing Django project. I have it installed on both the development machine and the "production" server. I've done the following on the development machine, then: added South app to settings.py, python manage.py syncdb python manage.py convert_to_south myproject.myapp then changed some models, then python manage...

custom module links not appear after upgrading the magento. it will work on local machine but not work on live?

Hello, I have one big issues don't know due to my mistake or magento's structure. i have update the magento to 1.4.1.1 and all work fine on my local machine but when i have moved it to live then in admin custom module's link are not appeared . i have also tried for clearing the cache and re login but it wont work.. can any one help?? ...