I have not used to work with SQL, and I almost do not know any DDL scripts. I am using ADO.NET Entity Framework 4 in Visual Studio 2010 with an EDMX designer and self-employment generator. This does the hard work for me, and I get a DDL-script that will be used to create the database when it does not exist. Everything goes fine ... Then I make changes to my EDMX model, possibly adding a property to the entity, and I get a new DDL to create a new database. But what about the old one? This database now contains some data, and of course I would like to move it to a new version. Ideally, I would like some tool to generate UPGRADE-DDL from my old CREATE-DDL to my new CREATE-DDL, while saving as much data as possible from the old database. But I can not find such a function in VS2010,and I canβt find any resources about this when searching on the net, which seems strange because it must be a very common problem, right? Or am I missing something? I can make many changes and additions to my schema using the EDMX constructor, and I do not want to manually write the DDL script update. Im not good enough with DDL to do this ... How does everyone do it? I'm confused...
source
share