All updated, have-at. On Thursday, November 13, 2014 3:44:12 PM UTC-5, Alexander Zaytsev wrote: > > 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 <xp.dev....@gmail.com > <javascript:>> 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 nhibernate-development+unsubscr...@googlegroups.com >> <javascript:>. >> 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 nhibernate-development+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
