Database Versioning with Entity framework idea required

Question

Hi All,

Anybody have experience/idea working on or creating database versioning tool or integrating the feature of versioning in the database entities. There is a requirement to enhance an existing WPF composite application to include versioning feature for the database that has following
features.

•Change tracking: all data entities should be tracked so that it should be possible for the state of the database to be
reconstructed at specific (tag points) in time.

•Releases: It should be possible to mark the state of the database a specific points in time to enable
(tagged) releases. It should be possible to give these tagged releases relevant names.

•Hierarchy: It should be possible to create tagged releases at any
point in the data entitity hierarchy.

•Documentation: When a data entity is
changed and saved back into the database, a change note should be provided. This
must be tagged with the data/time of the save and the username of the person
saving it.

•Release Notes: It should be possible to construct a list of all
changes made to the database between any two tagged releases.

•Differences:
It should be possible to show differences between any two tagged
releases.

•#Branching: It should be possible to branch
development of the database at any level of the hierarchy.

•Automation: #Changing one data entity may cause other
data entities which reference it, or rely on it, to change. These changes must
be tracked automatically through the database and #versioned
appropriately.

•Instances: The addition of instances of data entities to
entity databases should be considered part of the version control
system.

•Efficiency: The #version control system should be efficient both in time taken and memory usage.

Any idea would be helpful. Thanks a lot for reply in advance.

---

Happy Coding & Regards, Ashish

Answer 1

Tagging along for answer, thanks!

---

JP Cowboy Coders Unite!

Answer 2

Hi ashishjoshi.007,

Because your issue is more relative to Entity Framework, so I will move your thread to Entity Framework forum to get better support:

http://social.msdn.microsoft.com/Forums/en/adodotnetentityframework/threads

Best regards,

---

Sheldon _Xiao
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 3

Ashishkumar,

From a support perspective this is really beyond what we can do here in the forums. If you cannot determine your answer here or on your own, consider opening a support case with us. Visit this link to see the various support options that are available to better meet your needs: http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone.

Terrell AN

---

Terrell An -MSFT