-
Notifications
You must be signed in to change notification settings - Fork 0
/
DatabaseProjectWWI_PS.sqlproj
112 lines (112 loc) · 5.83 KB
/
DatabaseProjectWWI_PS.sqlproj
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
<?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>
<Name>DatabaseProjectWWI_PS</Name>
<SchemaVersion>2.0</SchemaVersion>
<ProjectVersion>4.1</ProjectVersion>
<ProjectGuid>{6EF9A4DC-F47D-4AAD-B905-FB495F35A9D6}</ProjectGuid>
<DSP>Microsoft.Data.Tools.Schema.Sql.Sql150DatabaseSchemaProvider</DSP>
<OutputType>Database</OutputType>
<RootPath>
</RootPath>
<RootNamespace>DatabaseProjectWWI_PS</RootNamespace>
<AssemblyName>DatabaseProjectWWI_PS</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>
<PropertyGroup>
<VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">11.0</VisualStudioVersion>
<!-- Default to the v11.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)' == ''">11.0</VisualStudioVersion>
</PropertyGroup>
<Import Condition="'$(NetCoreBuild)' == 'true'" Project="$(NETCoreTargetsPath)\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
<Import Condition="'$(NetCoreBuild)' != 'true' AND '$(SQLDBExtensionsRefPath)' != ''" Project="$(SQLDBExtensionsRefPath)\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
<Import Condition="'$(NetCoreBuild)' != 'true' AND '$(SQLDBExtensionsRefPath)' == ''" Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
<ItemGroup>
<PackageReference Condition="'$(NetCoreBuild)' == 'true'" Include="Microsoft.NETFramework.ReferenceAssemblies" Version="1.0.0" PrivateAssets="All" />
</ItemGroup>
<ItemGroup>
<Folder Include="Properties" />
<Folder Include="Sequences\" />
<Folder Include="Sequences\Sequences\" />
<Folder Include="Security\" />
<Folder Include="Sales\" />
<Folder Include="Sales\Tables\" />
<Folder Include="Sales\StoredProcedures\" />
<Folder Include="dbo\" />
<Folder Include="dbo\Tables\" />
<Folder Include="dbo\StoredProcedures\" />
<Folder Include="Application\" />
<Folder Include="Application\Tables\" />
<Folder Include="Application\StoredProcedures\" />
</ItemGroup>
<Target Name="BeforeBuild">
<Delete Files="$(BaseIntermediateOutputPath)\project.assets.json" />
</Target>
<ItemGroup>
<Build Include="Sequences\Sequences\TransactionID.sql" />
<Build Include="Sequences\Sequences\PersonID.sql" />
<Build Include="Sequences\Sequences\OrderLineID.sql" />
<Build Include="Sequences\Sequences\OrderID.sql" />
<Build Include="Sequences\Sequences\CountryID.sql" />
<Build Include="Security\SqlRoleMembership.sql" />
<Build Include="Security\Sequences.sql" />
<Build Include="Security\Sales.sql" />
<Build Include="Security\DBStats_1.sql" />
<Build Include="Security\DBStats.sql" />
<Build Include="Security\Application.sql" />
<Build Include="Sales\Tables\Orders.sql" />
<Build Include="Sales\Tables\OrderLines.sql" />
<Build Include="Sales\Tables\CustomerTransactions.sql" />
<Build Include="Sales\StoredProcedures\usp_GetFullProductInfo.sql" />
<Build Include="Sales\StoredProcedures\usp_FindOrderByDescription.sql" />
<Build Include="Sales\StoredProcedures\usp_CustomerTransactionInfo.sql" />
<Build Include="Sales\StoredProcedures\usp_CustomerOrdersByDate.sql" />
<Build Include="Sales\StoredProcedures\usp_CustomerOrderInfo.sql" />
<Build Include="dbo\Tables\StockItemIDs.sql" />
<Build Include="dbo\Tables\OrderLinesList.sql" />
<Build Include="dbo\Tables\OrderDates.sql" />
<Build Include="dbo\Tables\NewTable-1.sql" />
<Build Include="dbo\Tables\CustomerIDs.sql" />
<Build Include="dbo\Tables\CommandLog.sql" />
<Build Include="dbo\StoredProcedures\sp_WhoIsActive.sql" />
<Build Include="dbo\StoredProcedures\IndexOptimize.sql" />
<Build Include="dbo\StoredProcedures\CommandExecute.sql" />
<Build Include="Application\Tables\People.sql" />
<Build Include="Application\Tables\Countries.sql" />
<Build Include="Application\StoredProcedures\usp_GetPersonInfo.sql" />
</ItemGroup>
</Project>