Alter table's schema about fluentmigrator

[jtreuting]

No it doesn't currently support that. The only schema support currently is the ability to work with tables in specific schemas instead of the default dbo.

But that seems like something that could be added pretty easily. Feel free to fork the project and take a crack at it if you wish.

[kberridge]

What do you think the fluent interface should be for this?

Rename.Table( "tbl" ).InSchema( "a" ).To( "tbl" ).InSchema( "b" );
-or-
Alter.Table( "tbl" ).InSchema( "a" ).ToSchema( "b" );
-or-
Transfer.Table( "tbl" ).InSchema( "a" ).ToSchema( "b" );
-or-
something else?

[jtreuting]

My initial thought is that we would have something like the following:

Create.Schema("schema");
Delete.Schema("schema");
And there is no rename so we don't need that.

Alter is a little more difficult in my mind because you are really altering a table and assigning it a new schema, not altering the schema itself. So I don't think Alter.Schema makes the most sense.

I've added a new Alter.Table() syntax that allows for both AddColumn() and AlterColumn() at https://github.com/jtreuting/fluentmigrator/tree/createcolumn that isn't in the main code yet. But maybe this falls under that syntax.

So I think I like the Alter.Table("tbl").InSchema("a").ToSchema("b").

I'll probably push my Alter.Table changes later today or tonight to the master codebase so then you can grab that and go from there if you want.

[jtreuting]

Had some time right now so just comitted the Alter.Table syntax into the master code, so you can fork that and add the changes for Schema if you'd like.

[jtreuting]

This has been merged into the main branch, thanks.