Hi. I need to write a lot of DDL commands but I have to do it for each database vendor that I use. The intention is to update the schema but not like SchemaUpdate does. The problem is that SchemaUpdate just update the whole schema but I need a more controlled way to do this.
This would help me make a conversion library since I need to update the database schema in most of the times that I update my application. So, Let's suppose that I have a table like this: Table Person columns Id, Name. 1 - First Person 2 - Second Person ... But the next version of my system I need to create two columns (FirstName and LastName), copy the column Name data splitting it, and than I'll drop the column Name. Using SchemaUpdate will lost all data of column Name and columns FirstName and LastName will be created but empty. If I try to write it by hand I'll need to make it customized to each database vendor This is a very simple example because the constraints are a very big problem. I was thinking if NHibernate had a Criteria like or even just simple functions that would let us create tables, columns, fk's, drop them, and so on. Is there a simple way to do this, with or without NHibernate that I don't know? Thank you. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhusers@googlegroups.com To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
