25
голосов
2ответов
3868 просмотров

Core Data Migration Across Multiple Version Upgrades

I have an iPhone app that uses Core Data. I did an update and used Lightweight Migration to go from V1 to V2 of my MOM (Managed Object Model). This worked perfectly. What happens when I want to go to V3 (and beyond) of my MOM? If I decide to continue with Lightweight Migration, will it autom...

0
голосов
1ответов
185 просмотров

Oracle Migration Workbench

Does anybody know anything about using Migration Workbench to migrate db2 database to oracle 10G? I am getting a strange SQL1402N error when I try to get source capture.

15
голосов
5ответов
10834 просмотров

How might you clone a database table via Rails migration?

I want a migration to create a clone of an existing table by just suffixing the name, including all the indexes from the original table. So there's a "snapshots" table and I want to create "snapshots_temp" as an exact copy of the table (not the data, just the table schema, but including the in...

0
голосов
4ответов
100 просмотров

What do our customers have from migrating from .Net 2.0 to .Net 3.5?

I found very much about the benefits of using a newer .Net version for programmers (LINQ, WPF etc.) but I didn't find anything about the benefits for our customers. So, I'm thinking about migrating our application (WinForms, C#, .Net2.0) from .Net2.0 to .Net3.5 and I need answers to the question...

6
голосов
3ответов
6954 просмотров

Should I rebuild table indexes after a SQL Server 2000 to 2005 database migration

I'm tasked with doing a SQL Server 2000 to 2005 migration. I will be doing a side-by-side migration. After restoring from a backup I plan to do the following: ALTER DATABASE <database_name> SET COMPATIBILITY_LEVEL = 90; DBCC CHECKDB(<database_name>) WITH NO_INFOMSGS DBCC UPDATEUSA...

4
голосов
3ответов
1713 просмотров

PHP denying use of short hand ""

I just installed php 5.3.0 and it won't run php scripts utilizing short open tags like , only

0
голосов
4ответов
5126 просмотров

Migrating BO Reports between environments

We have the standard 3 environment setup of development, testing and production. Each environment has their own report server, web server, database server, etc. Part of our migration is to move our business objects (xi r2) reports between the servers but as of right now we need to manually upda...

1
голосов
1ответов
61 просмотров

Do I need to have a "references" column in both my Question and Answer models?

If I have a has_many and belongs_to relationship between Questions and Answers: class Question < ActiveRecord::Base has_many :answers end class Answer < ActiveRecord::Base belongs_to :question end Do I also need to modify the migration files to use "references": class CreateAnswers...

1
голосов
1ответов
99 просмотров

How can I go about automating the testing of the migration of local web apps from IE6 to IE8?

I have been researching this a wee bit and it seems to boil down to: 'Eyeball Mark 1' The best tip seems to be the use of SuperPreview from Microsoft's Expression team. If anyone has automated a way to go about this I would love to hear about it. Also, I believe that SuperPreview requires a w...

0
голосов
3ответов
271 просмотров

Why do migrations need the table block param?

Why does the ruby on rails migration syntax look like this: create_table :my_table do |t| t.integer :col t.integer :col2 t.integer :col3 end And not: create_table :my_table do integer :col integer :col2 integer :col3 end Personally I find the second snippet m...

1
голосов
2ответов
365 просмотров

Migrating a directory to a different svn repository

I have code in an svn repository, call it repository A. Now say that I need to move the contents to repository B, but repository B has already been active for a while for other projects. Is it possible to move a particular directory from repository A to repository B, preserving the file history? ...

2
голосов
1ответов
305 просмотров

Why doesn't this simple Rails migration update my database?

I've got a very simple migration that adds a single boolean column: class AddMuteToPreferences < ActiveRecord::Migration def self.up add_column :preferences, :mute_audio, :boolean, :default => false end def self.down remove_column :preferences, :mute_audio end end I run ...

7
голосов
5ответов
5336 просмотров

What is the down migration for adding a polymorphic reference

I have the folowing migration but don't know what to use in the down method change_table :addresses do |t| t.references :addressable, :polymorphic => true end

2
голосов
2ответов
1036 просмотров

Migrating from prototype to jquery

I am migrating my js lib from prototype to jquery. However, I don't know how to replace the following code: var utilityMethods = { autoHide : function(element) { //... } Element.addMethods('SPAN', utilityMethods); Is there a jQuery equivalent for extending the DOM?...

5
голосов
7ответов
4166 просмотров

Move project from Delphi 3 to Delphi 2010

I've been asked to re-open a project I wrote in 1998/99 in Delphi 3 and which has been running stably since then. I have the Delphi 3 code base on an aging Windows 98 machine which exists only to keep this project alive. Obviously, I'd like to bring the source code base into the 21st century be...

3
голосов
5ответов
3416 просмотров

Can a Microsoft Access Forms application be switched to work with a SQL back end?

I was asked to provide an estimation to change a relatively small app designed with MS Access to use a SQL database. First, is this even possible? I never worked enough with Access, so I'd like to know. If it's possible can you please point me to some websites with tutorials regarding this? Sec...

148
голосов
19ответов
173640 просмотров

List all sequences in a Postgres db 8.1 with SQL

I'm converting a db from postgres to mysql. Since i cannot find a tool that does the trick itself, i'm going to convert all postgres sequences to autoincrement ids in mysql with autoincrement value. So, how can i list all sequences in a Postgres DB (8.1 version) with information about the tabl...

3
голосов
3ответов
3229 просмотров

Mantis to Bugzilla migration?

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...

3
голосов
2ответов
1410 просмотров

Seam 2.0 to 2.1 (2.2) migration

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 ...

46
голосов
6ответов
5531 просмотров

When (if) to consolidate ActiveRecord migrations?

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 cour...

1
голосов
1ответов
1941 просмотров

Microsoft SQL Server to Oracle Data Migration (Conversion) (Other RDBMS ok, too)

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 f...

10
голосов
1ответов
3261 просмотров

Defining methods in Rails migrations

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 ...

6
голосов
5ответов
1284 просмотров

Managing Rails Migrations for different branches on the same machine

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, ...

1
голосов
2ответов
936 просмотров

Change directory and branch within CVS repository to read-only

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...

1
голосов
1ответов
942 просмотров

DotNetNuke 5 - Are there any best practices for migrating existing aspx-based website into DotNetNuke

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 edito...

1
голосов
1ответов
165 просмотров

How do you handle SubSonic 'relationships' with migration?

According to this article: http://subsonicproject.com/docs/3.0_Migrations 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 bu...

0
голосов
1ответов
113 просмотров

Creating and testing a default record in Rails

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 developmen...

3
голосов
1ответов
2905 просмотров

Ruby on Rails database migration not creating foreign keys in MySQL tables

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 fol...

0
голосов
1ответов
284 просмотров

Adding defaults and indexes to a script/generate command in a Rails Template?

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("sc...

1
голосов
2ответов
1633 просмотров

Is it possible to use a custom column type in a Rails migration?

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 th...