migration

Manual Core Data schema migration without "document changed" warning?

The data model for my Core Data document-based app (10.5 only) is in a framework, so automatic schema upgrades using a Core Data mapping model don't appear to work. It appears that the Core Data machinery doesn't find the appropriate data models or mapping model when they are not in the app's main bundle. So, instead of using the automat...

Rails Schema creation problem

I am using Jruby and rails 2.2.2. My problem is I have a migration that is not being correctly written to the database schema. Here is my migration: class CreateNotes < ActiveRecord::Migration def self.up create_table(:notes, :options => 'ENGINE=MyISAM') do |t| t.string :title t.text :body t.timestamps e...

Synchronization of sql server 2000 and postgresql 8.3

the scenario: Two databases(each has a database named, for example testdb): MS Sql Server 2000 Postgresql 8.3 I need to synchronize these two testdbs, actually the direction is from SqlServer to Postgresql. The structure of testdb on SqlServer may change occasionally. I only need tables and data of testdb synchronized, exclude ind...

How do I migrate my Netbeans themes to other computers?

Short of copying the entire .netbeans directory is there any way to transfer custom Netbeans color schemes to other computers? I am using the latest (6.5). ...

Do you plan move from ASP.Net Web Forms to ASP.Net MVC?

If yes, when? and how much time do you think that the process will take to migrate your current projects (if it's the case)? ...

Are there performance benefits when upgrading SQL2000 to SQL2005?

I've had a look at this question but there are no responses regarding performance. Are there any performance benefits from doing a simple upgrade from SQL2000 to SQL2005? I am thinking a line of business OLTP datbase. I am not using OLAP or FTI. ...

Registering custom webcontrol inside mvc view?

I am in the middle of a project where I am migrating some code for a website from WebForms to MVC - unfortunatly there's not enough time to do it all at once, so I will have to do some... not so pretty solutions. I am though facing a problems with a custom control I have written that inherits from the standard GridView control namespac...

Migrating From Visual FoxPro

I work for a company that had a large number of applications based on Visual FoxPro. The company is now looking for a migration strategy away from VFP to another language for its desktop applications (and web applications using west-wind). There are two consideration to be made in the coming years (support for VFP from Microsoft will ...

Add Rows on Migrations

Hi! I'd like to know which is the preferred way to add records to a database table in a Rails Migration. I've read on Ola Bini's book (Jruby on Rails) that he does something like this: class CreateProductCategories < ActiveRecord::Migration #defines the AR class class ProductType < ActiveRecord::Base; end def self.up #CREAT...

What should I look out for when migrating a project from VS2003 to VS2005

In the very near future I'll be migrating some web applications from VS2003 projects to VS2005 projects. What should I watch out for? Anyone done this in the past and have it go bad? How much time should I expect it will take to migrate a project? I know this is more than one question, but please provide your experiences with anythin...

Migrating from CPython to Jython

I'm considering moving my code (around 30K LOC) from CPython to Jython, so that I could have better integration with my java code. Is there a checklist or a guide I should look at, to help my with the migration? Does anyone have experience with doing something similar? From reading the Jython site, most of the problems seem too obscur...

Why my ASP.NET application broke after a migration?

My web application worked very well in a Windows Server 2003 with .NET Framework 2.0. When I migrated to Windows Server 2008 with .NET Framework 3.5. With the same code running in both servers the difference between them was the following: for a given async ASHX (IHttpAsyncHandler) the previous server automatically answered the request ...

MySQL: Migrating Queries from v4 to v5

When migrating a project from MySQL 4 to MySQL 5, what are the primary things I need to address in order to ensure queries remain compatible? In general things should be fine, but I know that some things that worked implicitly in MySQL 4 queries have to be defined explicitly in MySQL 5 (but I can't for the life of me remember what exaxt...

Rails unit tests fail because of unique constraint on schema_migrations

I'm trying to run rake test:units and I keep getting this: Mysql::Error: Duplicate entry '2147483647' for key 1: INSERT INTO `ts_schema_migrations` (version) VALUES ('20081008010000') The "ts_" is there because I have ActiveRecord::Base.table_name_prefix set. I'm confused because there is no value '20081008010000' already in the tabl...

Mainframe to .NET migration

Hi, What are the various tools available for migrating a Mainframe application (front end, DB, Business Logic) into .NET (C#.NET or VB.NET) and SQL Server 2005. The current Mainframe system has: CICS - front end, COBOL - language IDEAL and DATAComDB - database. Thanks in advance. Ajish ...

Can you connect to a MS Access database from Ruby running on a Mac?

I'm pretty sure the answer is "no" but I thought I'd check. Background: I have some legacy data in Access, need to get it into MySQL, which will be the DB server for a Ruby application that uses this legacy data. Data has to be processed and transformed. Access and MySQL schemas are totally different. I want to write a rake task in Ru...

Tool to Audit Code Moves to production Web Servers?

My team recently received the results of an External Audit and we must correct one item. They want us to change the way we move code to our production environment. We currently use source control and a ticketing system for all code changes and move requests etc.. The problem comes in with how the code is pushed to our production webser...

Migration from crystal reports 8 to crystal reports 2008

How to migrate Crystal Reports 8.0 to Crystal Reports 2008? The crystal reports which had stored procedures of 8.0 are not executing in 2008, can anyone help? We are using Seagate Crystal reports 8 and want to migrate all the programs to Crystal Reports 2008 Visual Studio Can you please explain the pros and cons of this.Thanks ...

Exporting/Importing Stored Procedures between DBs

I have two SQL Server 2005 databases, one is for development and the other is on the final production server. I would like to know the fastest way of ensuring that the production database has the exact same stored procedures (number and most recent version). Assumptions: Databases have same table schema. Production database is curren...

Queries for migrating data in live database?

I am writing code to migrate data from our live Access database to a new Sql Server database which has a different schema with a reorganized structure. This Sql Server database will be used with a new version of our application in development. I've been writing migrating code in C# that calls Sql Server and Access and transforms the dat...