migration

Porting MS SQL stored procedures to MySQL

i have about 140 - 150 stored procedures that I need to migrate from MS SQL 2005 to MySQL 5.1 After succesfully porting 0 of them in the last eight hours I decied to drop by and ask if anyone has any experience, or tips, or knows some util app that can help. MySQL Administrator is not very helpfull, with a frustrating "MySQL Error numb...

Does ASP.NET MVC perform better under IIS7 versus IIS6?

I'm running my ASP.NET MVC app on an IIS6 host right now, and they're not willing to upgrade my server, nor move my site to an IIS7 server - unless I purchase a new account to transfer to. Under IIS6 I understand there are a lot of wildcard mappings happening to get the .net framework to process the incoming connections for each type. ...

Machine Migrations wireup problem.

Hi All, I've been trying to wire up one of my projects to use Machine.Migrations for database migrations. However, I haven't been able to do that. I've been getting weird errors. I've tried using the MSBuild task but am getting the following error. Target MigrationMachine: D:\repositories\core\playground\minhajuddin\MachineMigrations...

Conditional compiling according to VC++ compiler version

I am in the process of migrating our VC++ project from Visual Studio 2005 (VC8) to Visual Studio 2008 (VC9). Some of the projects in the solution have paths to third party libraries in their 'Additional Library Directories' field in the project settings. The paths look something like this: ..\SomeLibrary\Lib\vc9\x86 It would be really u...

Migrating large CVS repository to SVN

I have a large CVS repository module (~2.2GB of CVS and has 10 years of active development). I'm attempting to migrate it to SVN in order to host it on Google Code, which has about 1GB limit. Is there a way to do a partial migration, where I only migrate the last year worth of changes only? cvs2svn and cvs2ps in the documentation disc...

Know of a good migration plan for SSRS 2005 reports?

Traditionally, our plucky team of developers have always migrated our own reports into production. This task is now being taken up by our support staff, who'll need detailed instructions to do so. We have always deployed straight from VS2005, which can be made available to the new migrators. Is there a better way to migrate these repo...

Migrating Data in a Rails Migration

Let's say you have "lineitems" and you used to define a "make" off of a line_item. Eventually you realize that a make should probably be on its own model, so you create a Make model. You then want to remove the make column off of the line_items table but for every line_item with a make you want to find_or_create_by(line_item.make). Ho...

What is the best way to organize file version migration code?

I'm writing a plug-in for another program through an API. To save it's current state, my plugin stores an instance of a Project object to the file by serializing it to XML and storing it in a user string, a feature provided by the API. It also stores a separate string that contains the version number of the plug-in currently being used. ...

Converting from Mercurial to Subversion

Due to lack of Mercurial support in several tools, and managerial oppression it has become necessary to convert several trial Mercurial repositories to Subversion in order to conform with the company standard. Are there any tools or suggestions for how to achieve this without a loss of revision history and the like? ...

schema.rb not updating after transfer to a new machine

I transfered a project to a new machine. Everything works. I can run migrations and they update the mysql database. However, the schema.rb file doesn't acknowledge the changes. I checked the read/write permissions for schema.rb are OK. Does anyone have any idea about what could cause this problem. I'm using Rails version 2.3.5. ra...

Should I flatten Rails migrations?

It's possible to replace db/migrate/* with the contents of db/schema.rb, so that you only have one migration step. Do any of you ever do this? Why? ...

Live, shared hosted, ASP.NET MVC site migration to Windows Azure

I have an existing ASP.NET MVC based website. Very typical: XHTML, CSS, jQuery, C#, LINQ2Sql. Web.config tells app where to connect for SQL database. Are typical websites like this easy to port to Windows Azure? What sort of headaches should I be ready for if I decided to do this? It's not necessary at this time, but I'm planning for w...

Relative paths issues for ImageButton / LinkButton

Hi I have recently migrated from .Net 1.1 to 3.5, and none of my ImageButton's or LinkButton's work. Not only do they not show the image, but when pressed, they redirect back to the root of the site; and the 'onClick' EventHandler doesn't fire. E.g. If I click an ImageButton on the page: http...../MyWebsite.ecom/Project1/frontend/...

MySQL UTF8 Database migration

Hi everyone, I'm having problems to migrate an utf8 database to another server... Each source and destination table has a "DEFAULT CHARSET=utf8". I use mysqldump to dump data and mysql < file.sql to import but when in the source table i have "España", in the destination i get "España". I read some guides, i used --default-character-...

Rails - Data Migration vs. value in DB

I have a question about where values in dropdowns are coming from: I have a migration that set up the original table with some initial values: add_column :contracts, :signature_status_id, :integer # lookup data sig = SignatureStatus.new(:name => "Delivered") sig.save! sig = SignatureStatus.new(:name => "Signed") sig.save! I have a t...

Java Ajax WebApp - Tips and Pitfalls?

A coworker and I have started tech spec'ing a webapp project we're going to be working on together in our spare time. We've (mostly) settled on using: Eclipse for Java EE, ICEfaces (so that means JSF), Tomcat, Hibernate, MySQL. At work we use: IntelliJ IDEA, Struts, JSP, WebLogic, JDO, and Oracle. The only common solution we'll be using ...

Migrating a ListItem with a custom ContentType and Workflows between MOSS and WSS

Hello, I have a ListItem, with a custom ContentType that have personalizad Workflows, running in MOSS 07 Enterprise. I want to duplicate that ListItem into Servers with WSS, that will see that ListItem as readonly. And I want to use the Microsoft.SharePoint.Deployment, but I'm open to other solutions... Can i do that? Thanks in adv...

Should I use migrations to create folders?

I created a feature that requires two folders to work correctly. These folders didn't existed in the rails project so I had to create them. Now I need to push this functionality so that the other developers can use it as well. What do you think is the best practice: Create the folders locally and leave a note somewhere explaining that...

What does "Migrating a Django application" mean?

I kept thinking a lot about the meaning of migrating a Django app the last few days and heard about migrating Django apps with django-south. Maybe it's just the lack of sufficient English skills (as English is not my native language) or this is one of the things you confront in a programmer's life which are so simple, that it takes a gen...

Move websites from IIS7 to IIS 7.5

Can anyone suggest the best way of moving websites on server1 with IIS7 to server2 with IIS 7.5 on it? I've read some articles which suggest copying the applicationHost.config file while preserving the configProtectedData node, but I'm concerned there may be settings in the IIS 7.5 config that don't exist in the current IIS7 config whi...