We are migrating several old mainframe applications for a customer to newer ASP.NET + SQL Server 2005 applications. Each application is generally thought of as standalone with no shared data between them, and do things like manage specialized inventory needs or vacation policy. The data is small and shouldn't outgrow a single SQL Serve...
Has anybody some experience with Kettle? I´m searching for a good data migration solution. ...
I am currently developing a system on a server running PHP version 5.1.6 thus I am forced to use Symfony 1.1 in the current environment. I am planning to migrate the application from 1.1 to 1.2 in the somewhat near future and I was wondering if anyone has any experience with this? I have attempted to migrate a system from 1.0 to 1.1 and ...
Hi all I need to create a new db in Sql Server, and move some data from an Oracle db to this Sql Server db; I read that this function can be implemented by using SSIS or the SQL Server Migration Assistant for Oracle; I wonder if someone can point me to a tutorial or a document where I can see how this task is performed step by step The ...
The newest search engine on emails from Yahoo was implemented in 2006 (details). IMO is better than Gmail, Hotmail and AOL. I'd love to know more details about implementation (indexes, technologies, etc). If anyone know something about this subject please let me know. ...
I wrote a program that outputs a Python program that fills my Django application with data. This program however is 23 MB large and my computer won't run it. Is there a solution for this? Another possible solution to fill the database would be using a fixture. The problem is that I don't know the new primary keys yet... or I would have ...
Duplicate: http://stackoverflow.com/questions/577132/why-are-c-collection-properties-not-flagged-as-obsolete-when-calling-properties I just migrated a .NET 1.1 project to .NET 2.0 using Visual Studio 2008. I know that there are references to obsolete methods in the project. But Visual Studio does not show "obsolete"-warnings after buil...
My migration is as follows: class CreateUsers < ActiveRecord::Migration def self.up create_table :users do |t| t.string :email t.string :password t.string :name t.boolean :male t.boolean :admin t.timestamps end end def self.down drop_table :users end end When I go to script/con...
I would like to create an enum field at sone migration I'm doing, I tried searching in google but I can't find the way to do it in the migration the only thing I found was t.column :status, :enum, :limit => [:accepted, :cancelled, :pending] but looks like the above code runs only on rails 1.xxx and since I'm running rails 2.0 this...
I have a SQL server database (Tables, Views, SP...). I need to convert this database to Oracle 10g. How can I do it? ...
The databases are prohibitively large (> 400MB), so dump > SCP > source is proving to be hours and hours work. Is there an easier way? Can I connect to the DB directly and import from the new server? ...
I have to convert some code from classic ASP to ASP.NET 1) How can I best handle syntax as below, where it seems to fail because the code is inside a tag, and also perhaps because the condition is split over several tags. 2) Any tools or guidelines that are good on this kind of code? 3) Classic ADO. <li><a<% if "" = myFolder the...
If you have polymorphic belongs_to associations then references will add both of the columns required: create_table :products do |t| t.references :attachment, :polymorphic => {:default => 'Photo'} end will add an attachment_id column and a string attachment_type column with a default value of ‘Photo’. What, exactly, does this mean?...
I'd like to migrate an existing MySQL database (around 40tables, 400mb data) to Postgres before it gets bigger. I searched the web and tried some migration-scripts (some of them can be found here). None of them works seamlessly - if it would be just a few glitches I had to fix manually, it wouldn't be a problem, but the resulting dumps d...
A rails app I am developing currently has about 35 migrations up to this point. Since the application started as an experiment, there is a fair amount of meaningless churn in the migrations as I went back and forth between different ideas. Are there any drawbacks to collapsing migrations 1-35 into one migration? I was planning to do thi...
Hi, I am trying to learn Rails by working with different packages (ActiveRecord, ActiveSupport) without rails gem. I can't figure out how to create a database with three classes, though. Here's my rakefile: require 'rubygems' require 'activerecord' require 'yaml' task :default => :migrate desc "Migrate the database through ...
We've got a large classic asp application and we consider migrating to either asp.net or php. I don't want to talk about the pros and cons of either one, but I'd rather like to know whether there are ways to avoid a complete rewrite in one shot when migrating to php. We simply can't stop maintaining the current codebase just to do a rewr...
Migrations are undoubtedly better than just firing up phpMyAdmin and changing the schema willy-nilly (as I did during my php days), but after using them for awhile, I think they're fatally flawed. Version control is a solved problem. The main function of migrations is to keep a history of changes to your database. But storing a differen...
I'm in the process of reviewing a code base (~20K LOC) and trying to determine how to migrating it from 1.4.2 to 5. Obviously, it's not an overnight project and the suggestion which I have received is to write new code against Java 5 and migrate the old code in a piece-meal fashion. Also, I'm no expert in the new features in Java 5 (i.e....
I notice that a couple of weeks ago PHP 5.3 reached release candidate stage (woo!), but then seeing the list of already-deprecated functions finally being removed, that got me thinking about whether it would break any of my old code. Short of doing a suck-it-and-see test (installing on a test server and trying it out), are there any sor...