databaseutilities/databaseutilities.sqlproj at master · ericlivergood/databaseutilities · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">
  <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
  <PropertyGroup>
    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
    <Name>databaseutilities</Name>
    <SchemaVersion>2.0</SchemaVersion>
    <ProjectVersion>4.1</ProjectVersion>
    <ProjectGuid>{0987354f-aba9-4606-a28c-6e59ebb37b0a}</ProjectGuid>
    <DSP>Microsoft.Data.Tools.Schema.Sql.Sql110DatabaseSchemaProvider</DSP>
    <OutputType>Database</OutputType>
    <RootPath>
    </RootPath>
    <RootNamespace>databaseutilities</RootNamespace>
    <AssemblyName>databaseutilities</AssemblyName>
    <ModelCollation>1033, CI</ModelCollation>
    <DefaultFileStructure>BySchemaAndSchemaType</DefaultFileStructure>
    <DeployToDatabase>True</DeployToDatabase>
    <TargetFrameworkVersion>v4.5</TargetFrameworkVersion>
    <TargetLanguage>CS</TargetLanguage>
    <AppDesignerFolder>Properties</AppDesignerFolder>
    <SqlServerVerification>False</SqlServerVerification>
    <IncludeCompositeObjects>True</IncludeCompositeObjects>
    <TargetDatabaseSet>True</TargetDatabaseSet>
  </PropertyGroup>
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
    <OutputPath>bin\Release\</OutputPath>
    <BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>
    <TreatWarningsAsErrors>False</TreatWarningsAsErrors>
    <DebugType>pdbonly</DebugType>
    <Optimize>true</Optimize>
    <DefineDebug>false</DefineDebug>
    <DefineTrace>true</DefineTrace>
    <ErrorReport>prompt</ErrorReport>
    <WarningLevel>4</WarningLevel>
  </PropertyGroup>
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
    <OutputPath>bin\Debug\</OutputPath>
    <BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>
    <TreatWarningsAsErrors>false</TreatWarningsAsErrors>
    <DebugSymbols>true</DebugSymbols>
    <DebugType>full</DebugType>
    <Optimize>false</Optimize>
    <DefineDebug>true</DefineDebug>
    <DefineTrace>true</DefineTrace>
    <ErrorReport>prompt</ErrorReport>
    <WarningLevel>4</WarningLevel>
  </PropertyGroup>
  <!-- VS10 without SP1 will not have VisualStudioVersion set, so do that here -->
  <PropertyGroup>
    <VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">10.0</VisualStudioVersion>
    <!-- Default to the v10.0 targets path if the targets file for the current VS version is not found -->
    <SSDTExists Condition="Exists('$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets')">True</SSDTExists>
    <VisualStudioVersion Condition="'$(SSDTExists)' == ''">10.0</VisualStudioVersion>
  </PropertyGroup>
  <Import Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
  <ItemGroup>
    <Folder Include="Properties" />
    <Folder Include="Views" />
    <Folder Include="StoredProcedures" />
    <Folder Include="CS" />
    <Folder Include="CS\FileInfo" />
    <Folder Include="CS\StringUtilities" />
    <Folder Include="Functions" />
    <Folder Include="CS\FileOperations" />
    <Folder Include="StoredProcedures\Jobs" />
    <Folder Include="Tables" />
  </ItemGroup>
  <ItemGroup>
    <ArtifactReference Include="$(DacPacRootPath)\Extensions\Microsoft\SQLDB\Extensions\SqlServer\110\SqlSchemas\master.dacpac">
      <HintPath>$(DacPacRootPath)\Extensions\Microsoft\SQLDB\Extensions\SqlServer\110\SqlSchemas\master.dacpac</HintPath>
      <SuppressMissingDependenciesErrors>False</SuppressMissingDependenciesErrors>
      <DatabaseVariableLiteralValue>master</DatabaseVariableLiteralValue>
    </ArtifactReference>
    <ArtifactReference Include="$(DacPacRootPath)\Extensions\Microsoft\SQLDB\Extensions\SqlServer\110\SqlSchemas\msdb.dacpac">
      <HintPath>$(DacPacRootPath)\Extensions\Microsoft\SQLDB\Extensions\SqlServer\110\SqlSchemas\msdb.dacpac</HintPath>
      <SuppressMissingDependenciesErrors>False</SuppressMissingDependenciesErrors>
      <DatabaseVariableLiteralValue>msdb</DatabaseVariableLiteralValue>
    </ArtifactReference>
  </ItemGroup>
  <ItemGroup>
    <Build Include="Views\BlockingChain_vw.sql" />
    <Build Include="Views\GetSQL_vw.sql" />
    <Build Include="Views\GetSQLLite_vw.sql" />
    <Build Include="StoredProcedures\RestoreBackup_prc.sql" />
    <Build Include="StoredProcedures\DropDatabase_prc.sql" />
    <Build Include="Views\DefaultDirectory_vw.sql" />
    <Build Include="Views\repl_SchemaOptions_vw.sql" />
    <Build Include="Functions\repl_AddSchemaOption_fn.sql" />
    <Build Include="Functions\repl_DefaultSchemaOptions_fn.function.sql" />
    <Build Include="Functions\repl_GetSchemaOptions_fn.sql" />
    <Build Include="Functions\repl_IsSchemaOptionSet_fn.sql" />
    <Build Include="StoredProcedures\Jobs\StopJob_prc.proc.sql" />
    <Build Include="StoredProcedures\Jobs\StartJob_prc.proc.sql" />
    <Build Include="StoredProcedures\Jobs\RestartJob_prc.proc.sql" />
    <Build Include="StoredProcedures\Jobs\IsJobRunning_prc.proc.sql" />
    <Build Include="Tables\TimeZone_tbl.sql" />
    <Build Include="Tables\TimeZoneToTimeZoneOffset_tbl.sql" />
    <Build Include="Functions\GetLocalTime_fn.sql" />
    <Build Include="Functions\GetLocalTimeFromUTC_fn.sql" />
  </ItemGroup>
  <ItemGroup>
    <Compile Include="CS\FileInfo\Directories.cs" />
    <Compile Include="CS\FileInfo\Drives.cs" />
    <Compile Include="CS\FileInfo\Files.cs" />
    <Compile Include="CS\FileInfo\Path.cs" />
    <Compile Include="CS\StringUtilities\Concatenate.cs" />
    <Compile Include="CS\StringUtilities\EditDistance.cs" />
    <Compile Include="CS\StringUtilities\Regex.cs" />
    <Compile Include="CS\FileOperations\ExportAssembly.cs" />
  </ItemGroup>
  <ItemGroup>
    <Reference Include="System" />
    <Reference Include="System.Data" />
    <Reference Include="System.Xml" />
  </ItemGroup>
  <ItemGroup>
    <ProjectReference Include="CS\TimeZoneUtilities\TimeZoneUtilities.csproj">
      <Name>TimeZoneUtilities</Name>
      <Project>{868b009b-8e65-46ae-ac22-9c14316ce2a0}</Project>
      <Private>True</Private>
      <IsModelAware>True</IsModelAware>
      <GenerateSqlClrDdl>True</GenerateSqlClrDdl>
    </ProjectReference>
  </ItemGroup>
</Project>