Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / All-Topics

DbKeeperNet 1.4.1.1 Released

0.00/5 (No votes)
21 Jul 2010CPOL 5.5K  
DbKeeperNet 1.4.1.1 has been released

Abstract

Another version of this very useful component which will help you in managing relational database schema changes and database schema distribution was just now released.

What is New

The following changes have been made to the project:

  • Oracle support (tested on version 10g)
  • New precondition DbTriggerNotFound (supported only on Oracle and MSSQL)
  • New Oracle specific precondition OraDbSequenceNotFound
  • IDatabaseService interface extended by TriggerExists() method contract

Files are available for download on Google Code at http://code.google.com/p/dbkeepernet/downloads/list.

How to Use It

To enable DbKeeperNet within your project:

  1. Download the engine.
  2. Update your App.Config (or Web.Config).
  3. Prepare your database update script (check the sample projects within the source package).
  4. Add the following 8 lines of code to enable the DbKeeperNet within your project (the code below should be part of an installation procedure):
    C#
    using (UpdateContext context = new UpdateContext())
    {
       context.LoadExtensions();
       context.InitializeDatabaseService(connString);
    
       Updater updater = new Updater(context);
       updater.ExecuteXmlFromConfig();
    }

References

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)