Fantastic! I will try it today. Thank you for your great support!
Am Donnerstag, 13. November 2014 22:58:10 UTC+1 schrieb Jeffrey Becker: > > 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 <[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.
