migration

sybase server migration from aix to windows

I have a sybase server on aix . Now I need to migrate it to windows . How should I do ? Thank you ...

My rails migrations won't run, and I can't deploy my rails app. How can I start over?

At some point in my rails development I started making database changes (e.g. dropping or altering columns/tables) without using rails migrations. So now I get errors when I try to deploy my rails app from scratch. blaine@blaine-laptop ~/tmp/rbjacolyte $ rake db:migrate (in /home/blaine/tmp/rbjacolyte) == AddHashToTrack: migrating ====...

What's the deal with Rails' alter_table method?

I've been using sqlite3 for my database under development and my app has gotten complex enough that it's a bit slow to work with. I've just switched to MySQL and run rake db:create ; rake db:migrate and one of my migrations failed with the following error message: undefined method `alter_table` for #<ActiveRecord::ConnectionAdapters::M...

Rails migrations for postgreSQL schemas

I'm working on a multi-tenant rails application using PostgreSQL schemas for different clients. Rails migrations don't work with multiple schemas out of the box, so I made the following rake task to migrate all schemas and it seems to work. My question is if others have implemented better and more elegant solutions. I would also be reall...

Migrating legacy ASP.NET to MVC 2 (RC): HttpApplication events not firing, User principal is null

Problem I am trying to take an existing ASP.NET web application and manually migrate it over to use MVC 2 (I am currently running the RC). I followed several steps (I'll list in a moment) and seemed to have it working, but then I noticed I can't set the AuthorizeAttribute because User is null on the controller. Then I noticed that when ...

rails remove old models with migrations

I have a bunch of rails models that i'm re-writing into a single model to simplify my code and reduce unnecessary tables. I'm wondering what the best way to delete a model class and its table is. I want past migrations to still succeed, but I don't want to leave the empty models lying around. Do I have to manually delete the old mig...

How to run a data-modifying migration that uses strip_tags?

I'm adding a new column, summary, to an existing table. It will contain a plaintext snippet of the HTML from the column body. I want to create summaries for all existing emails when I run my migration. However, I can't figure out how to use strip_tags within my migration. Here's what I have so far: class AddSummaryToEmails < ActiveRec...

Update on Insert

Please read Update1 first! This is SSIS specific question. I have the following tasks: I need to periodically move data from table A in MySQL to Table B in MsSQL. Then all of the moved rows needs to be updated in Table A (change a single column value). I have accomplished task 1 by creating the following Data Flow: ADO NET Source ...

How to rename a database column in rails using migration?

I wrongly named one column as hased_password, should have been hashed_password instead. Can i use migration to correct it? ...

How do the different frameworks and cmses handle the dev > staging > production deployment problem?

It's a familiar problem: I've got some changes to push up the dev > staging > production chain, but in the mean time, content and users have been added to the database on the production server. I work with drupal a lot, and it's lousy at this because so much of the configuration winds up in the db. (There are some solutions that try to ...

Sharepoint Migration from one domain to another

I have an active sharepoint farm already built and I am wanting to create an exact mirror copy of the sites and all its contents into a different domain for develpoment and testing. The share point site is live and can not be brougt down I have tried using sharepoint designer to migrate the sites but this comes up with a multitude of err...

ETL recommendation for migrating PK/FK values? Easy is better than powerful.

What I need from the tool is fairly simple, and this is a one-time effort, so maintainability isn't a priority. We are just going to take 14 separate MySQL database instances and need to combine the data into one database. There are some 200 tables involved, so we need something that can ease the pain of letting db rows get assigned a ...

migration to JBoss 5.1 - Failed to create a new SAX parser

I am trying to deploy my application (packed in .war file) that work properly on JBoss 4.2.3 to JBoss 5.1 (using java 5). Currently during deployment time I see in the server.log the error: ... Caused by: org.jboss.xb.binding.JBossXBRuntimeException: Failed to create a new SAX parser ... Caused by: java.lang.ClassCastE...

Calling .NET 2.0 assemblies in .NET 1.1

Recently I developed a internal framework in .NET 2.0 version, which is basically classes and helpers. The problem is I have some .NET 1.1 sites and applications and would like to use my framework from them. I know that I can't call .NET 2.0 in .NET 1.1, but I have an idea. If I create another 2.0 project with ComVisible and reference...

What is the point of database migrations 'down'?

As all databases should be, the source for ours is versioned using source control. The database is upgraded using a series of SQL scripts generated by Red Gate's comparison tool, which is essentially the same as an 'up' migration in the numerous database migration frameworks that seem to have sprung up recently. But what's the point in ...

After migrating Drupal site, saving the admin pages re-directs to old url

I recently migrated a drupal website to a new domain name. The site works fine with one problem . Each time I try to save any data on any of the admin pages , I end up getting redirected to the old url. I have tried a lot to search and find an answer to this problem .. but to no avail. Kindly help . THanks ...

Drupal - Migrating to new server

I have a fairly new drupal installation with a few hundred nodes. I moved it from the development server to the production server. However, when I opened my homepage, it says page not found. After checking all my links, it seems that I can't get to any of my content. They exist in the node database, as well as the content type tables. I...

MS Access to Oracle easy Conversion / Migration

Are there any good easy to use softwares to export Access Database files to an Oracle 11g database? I know that this might not be the most usual case but applications grow, especially with old applications that uses old technologies such as Access in this case needs to be upgraded at some point. Tutorials and articles regarding Access ...

rails style database migrations for asp.net?

I am in love with the rails style of updating db schema. I can define a migration as a class with fairly simple, yet powerful syntax. I can run the updates with a single command and all of my models are updated. They are committed to source control and can be easily read, modified, and undone. My current way of doing it for my asp.net m...

Smells like ActiveRecord messes object attributes on save

I have got a bunch of records in locations table: ... *************************** 8. row *************************** id: 8 feed: http://feeds.bbc.co.uk/weather/feeds/rss/5day/world/4564.xml ... *************************** 11. row *************************** id: 11 feed: http://feeds.bbc.co.uk/weather/feeds/rs...