Hi community, After having used an application for over 10 years, and been constantly limited by its lack of extensibility, we have decided to rewrite it fully from scratch. Because the new architecture differs from the old application, the database is also different. Here comes the problem: Is there any industrial process for migrating...
When project grows up, the number of migrations starts to be pretty high, and as I look back, I see many migrations that could be refactored. Like merging create_posts and rename_posts_to_responses into create_responses. Is this a bad habbit or should I encourage refactoring migrations? ...
I'm new to CakePHP, and I'm trying to decide between the schema shell that comes with CakePHP and the migrations tools that were written by Joel Moss and Georgi Momchilov. So far I haven't found any direct support in either of them for creating foreign key constraints. It appears that you might be able to write raw SQL in a migration to...
Hi I want to use south in my django project as migration tool, but I have problem with using south in multiuser scenario: two guys working in same time and create on diffrent machines two migrations with same number on first PC: 0007_extend_lizard.py on second PC: 0007_swap_name_adopter.py in this case i can run ./manage migrate --...
Hi Everyone! I've looked around the Wordpress forums about this and didn't find anything so I thought I might try here. If you have a staging/dev Wordpress setup used for testing new pluging and such, how do you go about migrating the data in the staging database back to the production database? Is there a "Wordpress best practices" way...
Our application isn't going to use rails for any part of its final state, but migrations are a fantastic way to define schema in my experience, so I'd like to use just that one aspect of rails. Is this a reasonable thing to do? If not, are there any tools out there than can be used to perform the same sort of job? We have a three-stag...
I have to create a database schema with Rails migrations. I have lots of columns which contain quantities (kg) and prices (currency). Currently I use this: t.column :quantity, :decimal, :precision => 6, :scale => 3 t.column :value, :decimal, :precision => 6, :scale => 2 At the generator call I use quantity:decimal to identify my...
I'm trying to set up a Rails Template that would allow for comprehensive set-up of a specific Rails app. Using Pratik Naik's overview (http://m.onkey.org/2008/12/4/rails-templates), I was able to set up a couple of scaffolds and models, with a line that looks something like this ... generate("scaffold", "post", "title:string", "body:str...
I am trying to modify a database Migration in a Ruby on Rails application. I am using MySQL as my database and would like to add foreign keys to the table that is being created. I am using the following code and while the specifications for creating null values on appropriate columns is being followed no foreign key constraints are being...
Before all i'm not a windows administrator so that perhaps this question is totally nosense. We are going to migrate our windows file server to another machine, the people who is going to do the job know how to replicate the folders and files (copy/paste perhaps?) but they don't know how to migrate the file and folder user permissions. ...
I'm creating a user authentication system for my site. I want to add a default user, so that if I create a new site, or reset the database I will still be able to log in (and change the default user details). I have the code below in the migration. All seems to be working fine for the development database, but when it come to testing th...
According to this article: http://subsonicproject.com/docs/3.0%5FMigrations Bottom line: if you're a developer that is concerned about database design, migrations might not be for you. Ok, that's fine, I can treat the database as simply a persistent repository of data that doesn't contain any business logic. In other words, a glorifie...
Hello, our website resides on iis-server and is completely written with Expression Web using templates and pure html-pages based on those templates. There's also some slight functionality built using c# in code behind. Now i've been looking into DotNetNuke 5 as an alternative, so that our content editors (no tech bg) wouldn't have such...
We are moving to SVN and need to prevent commits to specific directories/modules within the CVS repository. What is the best way of doing this? I have currently set the filesystem permissions for this directory to read-only and seems to do the job for now - but is there a 'cvs' way of doing this? Also, can I make a specific branch read...
I'm a one-man-band at the company I work for. I develop a Rails application for internal use within the company. Since the beginning of the project I have used SVN for source control and done most, but not all, development in trunk. Occasionally, when I have had very significant changes to make, I have branched and made the changes mergi...
I'm trying to define a method inside a migration, but I'm getting an undefined method error: undefined method 'do_something_specific' for #<ActiveRecord::ConnectionAdapters::SQLite3Adapter:0x4868018> I'd rather not define it elsewhere, because it doesn't really relate to the rest of the application, just this specific migration. To b...
Hi all, Can you please give some tips or guidelines, best practices for MicroSoft SQL server to Oracle Data Migration? IMHO, it is something that comes best with experience. So I would like to benefit from your experience. Please share any insights that you have into design, modeling, testing or tuning for a data migration project. I wo...
As I move through the iterations on my application*(s) I accumulate migrations. As of just now there are 48 such files, spanning about 24 months' activity. I'm considering taking my current schema.rb and making that the baseline. I'm also considering deleting (subject to source control, of course) the existing migrations and creating a...
I was curious what kinds of obstacles have you encountered when migrating my app from seam 2.0 to 2.1. Obvious ones are mentioned in: migration guide, but I encountered some problems with rule based security, that are not mentioned there. Firstly I want to post descriptions of my problems and my solutions with migration, so people can...
Hi all! So we have this project which uses Mantis as bug tracker tool and in the company the corporate bug tracking tool is Bugzilla. This means we will have to use Bugzilla soon. I searched for tools that can be used to migrate from Mantis to Bugzilla and I only found this m2bz tool which seems to work for Mantis 0.17.5 and Bugzilla 2...