I've implemented rename for MySQL in FluentMigrator https://github.com/schambers/fluentmigrator/pull/166/
Best Regards, Alexander On Fri, Nov 14, 2014 at 8:44 AM, Jan Schubert <[email protected]> wrote: > Not all dialects support rename columns. > > No support found for Firebird and SQLite. > > MySQL needs the data type to change the column name: > ALTER TABLE "tablename" Change "oldcolumnname" "newcolumnname" ["Data > Type"] > > Other dialects: > Oracle = alter table tablename rename column oldcolumnname to newcolumnname > DB2 = ALTER TABLE tablename RENAME COLUMN oldcolumnname TO newcolumnname > Ingres = ALTER TABLE tablename RENAME COLUMN oldcolumnname TO newcolumnname > PostgreSQL = ALTER TABLE tablename RENAME COLUMN oldcolumnname TO > newcolumnname > Sybase = sp_rename 'tablename.oldcolumnname', 'newcolumnname' > > > Am Donnerstag, 13. November 2014 19:56:11 UTC+1 schrieb Jeffrey Becker: > >> I'm going to build in support in my repo shortly. If you could check the >> other dialects for column renaming support and let me know, that'd be >> awesome. >> >> In the mean-time you can always: >> >> Run(new SqlDdlOperation("EXEC sp_rename 'Test.Example', >> 'BetterExample', 'COLUMN';")); >> >> or implement a RenameColumnOperation and Run that. >> >> On Thursday, November 13, 2014 1:41:21 PM UTC-5, Jan Schubert wrote: >>> >>> Yes, that I mean. It is possible to rename a column with sp_rename on >>> mssql. >>> >>> EXEC sp_rename 'Test.Example', 'BetterExample', 'COLUMN'; >>> >>> >>> Am Donnerstag, 13. November 2014 15:26:45 UTC+1 schrieb Jeffrey Becker: >>>> >>>> er. Do you mean having a method off the fluent builder something like: >>>> >>>> surface.Alter.Table("Test").RenameColumn("Example", "BetterExample"); >>>> >>>> >>>> >>>> On Thursday, November 13, 2014 7:37:51 AM UTC-5, Jeffrey Becker wrote: >>>>> >>>>> I doubt it. Afaik, sql (or at least the mssqlserver dialect) doesn't >>>>> support renaming columns in the alter syntax. That an IDdlOperation which >>>>> generates the correct ddl shouldn't be hard to whip up. >>>>> On Nov 13, 2014 7:03 AM, "Jan Schubert" wrote: >>>>> >>>>>> You add support for altering columns, but it is possible to rename a >>>>>> column with ALTER? I saw your migration framework (Alpha) cannot rename a >>>>>> column. >>>>>> >>>>>> -- >>>>>> >>>>>> >>>>>> -- > > --- > You received this message because you are subscribed to the Google Groups > "nhibernate-development" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "nhibernate-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
