Forum: Ruby on Rails Active Record Migrations and SQL Server

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
rdifrango (Guest)
on 2005-11-16 07:37
(Received via mailing list)

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?

This topic is locked and can not be replied to.