Click here to Skip to main content
15,885,875 members
Search within:


Articles / Programming Languages / XML
 

DBKeeperNet - Keeps Your DB Schema Up-to-date

Rate me:
Please Sign up or sign in to vote.
4.88/5 (14 votes)
26 Aug 2014BSD4 min read 50.4K   575   89  
An article describing a simple .NET library which simply keeps your database schema up-to-date.
 
<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">
  <PropertyGroup>
    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
    <ProductVersion>8.0.50727</ProductVersion>
    <SchemaVersion>2.0</SchemaVersion>
    <ProjectGuid>{B97FDF3F-710F-41B3-8CD2-F0A5E3C88206}</ProjectGuid>
    <OutputType>Library</OutputType>
    <AppDesignerFolder>Properties</AppDesignerFolder>
    <RootNamespace>DbKeeperNet.Engine.Tests</RootNamespace>
    <AssemblyName>DbKeeperNet.Engine.Tests</AssemblyName>
    <IsWebBootstrapper>true</IsWebBootstrapper>
    <TargetFrameworkVersion>v2.0</TargetFrameworkVersion>
    <FileUpgradeFlags>
    </FileUpgradeFlags>
    <OldToolsVersion>2.0</OldToolsVersion>
    <UpgradeBackupLocation />
    <PublishUrl>http://localhost/DbKeeperNet.Engine.Tests/</PublishUrl>
    <Install>true</Install>
    <InstallFrom>Web</InstallFrom>
    <UpdateEnabled>true</UpdateEnabled>
    <UpdateMode>Foreground</UpdateMode>
    <UpdateInterval>7</UpdateInterval>
    <UpdateIntervalUnits>Days</UpdateIntervalUnits>
    <UpdatePeriodically>false</UpdatePeriodically>
    <UpdateRequired>false</UpdateRequired>
    <MapFileExtensions>true</MapFileExtensions>
    <ApplicationRevision>0</ApplicationRevision>
    <ApplicationVersion>1.0.0.%2a</ApplicationVersion>
    <UseApplicationTrust>false</UseApplicationTrust>
    <BootstrapperEnabled>true</BootstrapperEnabled>
  </PropertyGroup>
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
    <DebugSymbols>true</DebugSymbols>
    <DebugType>full</DebugType>
    <Optimize>false</Optimize>
    <OutputPath>bin\Debug\</OutputPath>
    <DefineConstants>DEBUG;TRACE</DefineConstants>
    <ErrorReport>prompt</ErrorReport>
    <WarningLevel>4</WarningLevel>
    <CodeAnalysisRuleSet>AllRules.ruleset</CodeAnalysisRuleSet>
  </PropertyGroup>
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
    <DebugType>pdbonly</DebugType>
    <Optimize>true</Optimize>
    <OutputPath>bin\Release\</OutputPath>
    <DefineConstants>TRACE</DefineConstants>
    <ErrorReport>prompt</ErrorReport>
    <WarningLevel>4</WarningLevel>
    <CodeAnalysisRuleSet>AllRules.ruleset</CodeAnalysisRuleSet>
  </PropertyGroup>
  <ItemGroup>
    <Reference Include="Castle.Core, Version=1.0.3.0, Culture=neutral, PublicKeyToken=407dd0808d44fbdc, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>..\External\Castle.Core.dll</HintPath>
    </Reference>
    <Reference Include="Castle.DynamicProxy2, Version=2.0.3.0, Culture=neutral, PublicKeyToken=407dd0808d44fbdc, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>..\External\Castle.DynamicProxy2.dll</HintPath>
    </Reference>
    <Reference Include="nunit.framework, Version=2.5.0.9122, Culture=neutral, PublicKeyToken=96d09a1eb7f44a77, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>C:\Program Files (x86)\TestDriven.NET 2.0\NUnit\2.5\nunit.framework.dll</HintPath>
    </Reference>
    <Reference Include="Rhino.Mocks, Version=3.5.0.2, Culture=neutral, PublicKeyToken=0b3305902db7183f, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>..\External\Rhino.Mocks.dll</HintPath>
    </Reference>
    <Reference Include="System" />
    <Reference Include="System.configuration" />
    <Reference Include="System.Data" />
    <Reference Include="System.Xml" />
  </ItemGroup>
  <ItemGroup>
    <Compile Include="AppConfigTests.cs" />
    <Compile Include="CustomUpdateStep.cs" />
    <Compile Include="Extensions\DatabaseServices\DatabaseServiceForeignKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\DatabaseServiceIndexTests.cs" />
    <Compile Include="Extensions\DatabaseServices\DatabaseServicePrimaryKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\DatabaseServiceStoredProceduresTests.cs" />
    <Compile Include="Extensions\DatabaseServices\DatabaseServiceTableTests.cs" />
    <Compile Include="Extensions\DatabaseServices\DatabaseServiceTests.cs" />
    <Compile Include="Extensions\DatabaseServices\DatabaseServiceTriggerTests.cs" />
    <Compile Include="Extensions\DatabaseServices\DatabaseServiceViewTests.cs" />
    <Compile Include="Extensions\DatabaseServices\FirebirdDatabaseServiceIndexTests.cs" />
    <Compile Include="Extensions\DatabaseServices\FirebirdDatabaseServiceLiveTests.cs" />
    <Compile Include="Extensions\DatabaseServices\FirebirdDatabaseServicePrimaryKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\FirebirdDatabaseServiceStoredProcedureTests.cs" />
    <Compile Include="Extensions\DatabaseServices\FirebirdDatabaseServiceTableTests.cs" />
    <Compile Include="Extensions\DatabaseServices\FirebirdDatabaseServiceTests.cs" />
    <Compile Include="Extensions\DatabaseServices\FirebirdDatabaseServiceTriggerTests.cs" />
    <Compile Include="Extensions\DatabaseServices\FirebirdDatabaseServiceViewTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MsSqlDatabaseServiceIndexTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MsSqlDatabaseServiceLiveTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MsSqlDatabaseServicePrimaryKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MsSqlDatabaseServiceStoredProcedureTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MsSqlDatabaseServiceTableTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MsSqlDatabaseServiceTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MsSqlDatabaseServiceTriggerTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MsSqlDatabaseServiceViewTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MsSqlDatabaseServiceForeignKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MySqlNetConnectorDatabaseServiceForeignKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MySqlNetConnectorDatabaseServicePrimaryKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MySqlNetConnectorDatabaseServiceIndexTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MySqlNetConnectorDatabaseServiceLiveTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MySqlNetConnectorDatabaseServiceTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MySqlNetConnectorDatabaseServiceTableTests.cs" />
    <Compile Include="Extensions\DatabaseServices\MySqlNetConnectorDatabaseServiceViewTests.cs" />
    <Compile Include="Extensions\DatabaseServices\OracleDatabaseServiceForeignKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\OracleDatabaseServiceIndexTests.cs" />
    <Compile Include="Extensions\DatabaseServices\OracleDatabaseServiceLiveTests.cs" />
    <Compile Include="Extensions\DatabaseServices\OracleDatabaseServicePrimaryKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\OracleDatabaseServiceStoredProcedureTests.cs" />
    <Compile Include="Extensions\DatabaseServices\OracleDatabaseServiceTableTests.cs" />
    <Compile Include="Extensions\DatabaseServices\OracleDatabaseServiceTests.cs" />
    <Compile Include="Extensions\DatabaseServices\OracleDatabaseServiceTriggerTests.cs" />
    <Compile Include="Extensions\DatabaseServices\OracleDatabaseServiceViewTests.cs" />
    <Compile Include="Extensions\DatabaseServices\PgSqlDatabaseServiceForeignKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\PgSqlDatabaseServiceIndexTests.cs" />
    <Compile Include="Extensions\DatabaseServices\PgSqlDatabaseServiceLiveTests.cs" />
    <Compile Include="Extensions\DatabaseServices\PgSqlDatabaseServicePrimaryKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\PgSqlDatabaseServiceTests.cs" />
    <Compile Include="Extensions\DatabaseServices\PgSqlDatabaseServiceTableTests.cs" />
    <Compile Include="Extensions\DatabaseServices\PgSqlDatabaseServiceViewTests.cs" />
    <Compile Include="Extensions\DatabaseServices\SQLiteDatabaseServiceForeignKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\SQLiteDatabaseServiceIndexTests.cs" />
    <Compile Include="Extensions\DatabaseServices\SQLiteDatabaseServiceLiveTests.cs" />
    <Compile Include="Extensions\DatabaseServices\SQLiteDatabaseServicePrimaryKeyTests.cs" />
    <Compile Include="Extensions\DatabaseServices\SQLiteDatabaseServiceTableTests.cs" />
    <Compile Include="Extensions\DatabaseServices\SQLiteDatabaseServiceTests.cs" />
    <Compile Include="Extensions\DatabaseServices\SQLiteDatabaseServiceViewTests.cs" />
    <Compile Include="Extensions\Preconditions\DbForeignKeyNotFoundTests.cs" />
    <Compile Include="Extensions\Preconditions\DbIndexNotFoundTests.cs" />
    <Compile Include="Extensions\Preconditions\DbProcedureNotFoundTests.cs" />
    <Compile Include="Extensions\Preconditions\DbTableNotFoundTests.cs" />
    <Compile Include="Extensions\Preconditions\DbTypeTests.cs" />
    <Compile Include="Extensions\Preconditions\DbViewNotFoundTest.cs" />
    <Compile Include="NonSplittingSqlScriptSplitter.cs" />
    <Compile Include="Extensions\Preconditions\StepNotExecutedTests.cs" />
    <Compile Include="Properties\AssemblyInfo.cs" />
    <Compile Include="SqlScriptSplitterTests.cs" />
    <Compile Include="UpdateContextTests.cs" />
    <Compile Include="UpdaterTests.cs" />
  </ItemGroup>
  <ItemGroup>
    <ProjectReference Include="..\DbKeeperNet.Engine\DbKeeperNet.Engine.csproj">
      <Project>{FFCF7DA4-C786-4999-8624-26C392D67315}</Project>
      <Name>DbKeeperNet.Engine</Name>
    </ProjectReference>
  </ItemGroup>
  <ItemGroup>
    <None Include="App.config" />
    <None Include="DiskUpdateTest.Config">
      <CopyToOutputDirectory>Always</CopyToOutputDirectory>
    </None>
    <None Include="TestConfiguredValues.config">
      <CopyToOutputDirectory>Always</CopyToOutputDirectory>
    </None>
    <None Include="TestDefaultValues.config">
      <CopyToOutputDirectory>Always</CopyToOutputDirectory>
    </None>
  </ItemGroup>
  <ItemGroup>
    <EmbeddedResource Include="CustomUpdateStep.xml" />
  </ItemGroup>
  <ItemGroup>
    <EmbeddedResource Include="Extensions\Preconditions\StepNotExecutedTests.xml" />
  </ItemGroup>
  <ItemGroup>
    <EmbeddedResource Include="Extensions\Preconditions\DbTableNotFoundTests.xml" />
  </ItemGroup>
  <ItemGroup>
    <EmbeddedResource Include="Extensions\Preconditions\DbViewNotFoundTests.xml" />
  </ItemGroup>
  <ItemGroup>
    <EmbeddedResource Include="Extensions\Preconditions\DbIndexNotFoundTests.xml" />
  </ItemGroup>
  <ItemGroup>
    <EmbeddedResource Include="Extensions\Preconditions\DbProcedureNotFoundTests.xml" />
  </ItemGroup>
  <ItemGroup>
    <EmbeddedResource Include="Extensions\Preconditions\DbForeignKeyNotFoundTests.xml" />
  </ItemGroup>
  <ItemGroup>
    <Content Include="DbKeeperNetNUnit.mdf">
      <CopyToOutputDirectory>Always</CopyToOutputDirectory>
    </Content>
    <Content Include="DbKeeperNetNUnit_log.ldf">
      <CopyToOutputDirectory>Always</CopyToOutputDirectory>
      <DependentUpon>DbKeeperNetNUnit.mdf</DependentUpon>
    </Content>
    <Content Include="Update.xml">
      <CopyToOutputDirectory>Always</CopyToOutputDirectory>
    </Content>
    <EmbeddedResource Include="Extensions\Preconditions\DbTypeTests.xml" />
  </ItemGroup>
  <ItemGroup>
    <BootstrapperPackage Include="Microsoft.Net.Client.3.5">
      <Visible>False</Visible>
      <ProductName>.NET Framework 3.5 SP1 Client Profile</ProductName>
      <Install>false</Install>
    </BootstrapperPackage>
    <BootstrapperPackage Include="Microsoft.Net.Framework.2.0">
      <Visible>False</Visible>
      <ProductName>.NET Framework 2.0</ProductName>
      <Install>true</Install>
    </BootstrapperPackage>
    <BootstrapperPackage Include="Microsoft.Net.Framework.3.5.SP1">
      <Visible>False</Visible>
      <ProductName>.NET Framework 3.5 SP1</ProductName>
      <Install>false</Install>
    </BootstrapperPackage>
    <BootstrapperPackage Include="Microsoft.Sql.Server.Express.1.0">
      <Visible>False</Visible>
      <ProductName>SQL Server 2005 Express Edition</ProductName>
      <Install>true</Install>
    </BootstrapperPackage>
    <BootstrapperPackage Include="Microsoft.Windows.Installer.3.1">
      <Visible>False</Visible>
      <ProductName>Windows Installer 3.1</ProductName>
      <Install>true</Install>
    </BootstrapperPackage>
  </ItemGroup>
  <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
  <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 
       Other similar extension points exist, see Microsoft.Common.targets.
  <Target Name="BeforeBuild">
  </Target>
  <Target Name="AfterBuild">
  </Target>
  -->
</Project>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The BSD License


Written By
voloda2
Team Leader NCR
Czech Republic Czech Republic
I'm software developer since 1996. I started with assembler on Intel 8051 CPUs, during years I was interested in C, C++, Sybase PowerBuilder, PHP, Sybase Anywhere Database, MSSQL server and multiplatform development.

Currently I'm developing in C++ and C# (this is my favorit and I spent some time with MCPD achievement). I'm also interested in design patterns.

Comments and Discussions

Permalink
Advertise
Privacy
Cookies
Terms of Use
Layout: fixed | fluid

Posted 4 Sep 2009

Article Copyright 2009 by voloda2
Everything else Copyright © CodeProject, 1999-2024

Web01 2.8:2024-04-02:1