I'm using migratordotnet to manage my database migrations. I'm running them on application setup like this, but I would also like to check on application startup that the migrations are up to date, and provide the option to migrate to latest. How do I tell if there are available migrations that need to be applied? I see that I can get...
I love Fluent NHibernate for building my DBs and so far haven't found a restriction that has halted me in my tracks. However on my current project I expect to release to production very early in the product lifecycle and hence expect there to be many small changes in the db schema as we progress. I'd like to track these DDL amd DML cha...
I have Migrator.net implemented in my project and I am removing a table from the current schema. My Up() simply contains Database.RemoveTable("FooTable"). But now I'm at a bit of a loss as to what I'm supposed to do for my Down(). Do I need to manually parse all past migrations for modifications on FooTable? Is there a way to run all pre...
I have a project that I am working on that requires the use of the Mysql Connector for NHibernate, (Mysql.Data.dll). I also want to reference another project (Migrator.NET) in the same project. The problem is even though Migrator.NET is built with the reference to MySql.Data with specific version = false, it still tries to reference the ...
I'm using Migrator.NET to write database migrations for the application. Marc-André Cournoyer wrote: Like any code in your application you must test your migrations. Ups and downs code. Do it part of your continuous build process and test it on as many different databases and environment as you can. How do I do that? Say I ...
I want to introduce database migrations into my project and would like to be able to generate my initial migration scripts from the database. I was wondering if there are any code generation tools around to do this? I was thinking of using migrator.net but am happy to use anything so long as I can get a tool to generate code for it. ...
Hi, I want to run MSBuild on a users PC as part of a WinForms ClickOnce deployment. That is after the application is downloaded and run (via clickonce) the application needs to kick off an MsBuild to handle database updates (using MigratorDotNet). Q - How can my application robustly kick off MsBuild? i.e. how can it be sure what pat...
Hi, Could I use migrator.net bare migration framework and just have a set of SQL files to do the upgrade/downgrade? i.e. just use the framework to check database version and which scripts to run etc? thanks ...
Hi, I develope an application in C#.Net 2.0, Windows. The App has a RSS Feed Reader for specific sites (to collect the biggest news). I found a very nice DLL for this in which I can very easy read the RSS. But my problem is the design, I tried a lot, how to display easy, quick and nice, but it sucks like hell, I tried nerly every contr...
Can someone point me in the right direction for creating indexes when using MigratorDotNet? I have some tables which need multi column indexes. Thanks ...
Hi guys, Brief introduction: I have this ASP.NET Webforms site with the particularity that it doesn't have only 1 database, it has many. Why? Because you can create new "instances" of the site on-the-fly. Every "instance" share the same codebase, but has its own database. These all databases have the same schema (structure) but of cours...
I am using migratordotnet to sync my SQLServer 2008 database and need to create a column of type Text... Am at a bit of a loss as to how to do this, as there is no System.Data.DbType.Text?? ...
I'm using Migrator.NET with a DB2 database and my current migration executes an ALTER TABLE statement, which causes the table to go into the "reorg pending state". This state requires the reorganisation of the table with > REORG TABLE TableName before I can do anything else with it. I tried executing this with Database["DB2"].Execut...