Active Record Migrations and SQL Server


I was looking at the ActiveRecordMigration module and I noticed that it
only supports MySQL and PostgreSQL. has anyone tested this with SQL
Server? Any thoughts on what it would take to get it there?

On a separate note, has anyone had to migrate a schema which does not
contain any ID columns? For example, I have a lot of tables that have
character based Primary Keys. So what I need to do is not only add the
ID column to the target table, but update any Foreign Keys that I have
to point to the new key. Or course, I have to maintain the data. Has
anyone built anything to handle this type of situation?