-
Notifications
You must be signed in to change notification settings - Fork 0
/
Federation.dbproj
148 lines (148 loc) · 8.5 KB
/
Federation.dbproj
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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
<?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>
<Name>Federation</Name>
<SchemaVersion>2.0</SchemaVersion>
<ProjectVersion>4.0</ProjectVersion>
<ProjectGuid>{67cbc824-a49e-4e9b-a947-360f3dfe65c3}</ProjectGuid>
<DSP>Microsoft.Data.Schema.Sql.Sql100DatabaseSchemaProvider</DSP>
<AppDesignerFolder>Properties</AppDesignerFolder>
<ShowWizard>True</ShowWizard>
<OutputType>Database</OutputType>
<RootPath>
</RootPath>
<IncludeSchemaNameInFileName>False</IncludeSchemaNameInFileName>
<ModelCollation>1033,CI</ModelCollation>
<DefaultFileStructure>BySchema</DefaultFileStructure>
<DeployToDatabaseAddToServerExplorer>True</DeployToDatabaseAddToServerExplorer>
<DeployToScript>True</DeployToScript>
<CatalogPropertiesFile>Properties\Database.sqlsettings</CatalogPropertiesFile>
<ServerPropertiesFile>
</ServerPropertiesFile>
<LoadSqlClrTypes>True</LoadSqlClrTypes>
<RootNamespace>Federation</RootNamespace>
<DefaultSchema>dbo</DefaultSchema>
<PreviousProjectVersion>4.0</PreviousProjectVersion>
<AllowServerObjects>False</AllowServerObjects>
<AllowDatabaseObjects>True</AllowDatabaseObjects>
</PropertyGroup>
<PropertyGroup Condition=" '$(Configuration)' == 'Release' ">
<OutputPath>.\sql\release\</OutputPath>
<BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>
<TargetConnectionString>Data Source=federation.database.windows.net;Persist Security Info=True;User ID=Imago;Pooling=False</TargetConnectionString>
<TargetDatabase>
</TargetDatabase>
<TreatWarningsAsErrors>False</TreatWarningsAsErrors>
<SuppressWarnings>
</SuppressWarnings>
<DeploymentConfigFile>Properties\Database.sqldeployment</DeploymentConfigFile>
<SqlCommandVariablesFile>Properties\Database.sqlcmdvars</SqlCommandVariablesFile>
<DeployToDatabase>True</DeployToDatabase>
</PropertyGroup>
<PropertyGroup Condition=" '$(Configuration)' == 'Debug' ">
<OutputPath>.\sql\debug\</OutputPath>
<BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>
<TargetConnectionString>Data Source=federation.database.windows.net;Persist Security Info=True;User ID=Imago;Pooling=False</TargetConnectionString>
<TargetDatabase>
</TargetDatabase>
<TreatWarningsAsErrors>False</TreatWarningsAsErrors>
<SuppressWarnings>
</SuppressWarnings>
<DeploymentConfigFile>Properties\Database.sqldeployment</DeploymentConfigFile>
<SqlCommandVariablesFile>Properties\Database.sqlcmdvars</SqlCommandVariablesFile>
<DeployToDatabase>True</DeployToDatabase>
</PropertyGroup>
<!--Import the settings-->
<Import Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v10.0\TeamData\Microsoft.Data.Schema.SqlTasks.targets" />
<ItemGroup>
<Folder Include="Scripts" />
<Folder Include="Scripts\Pre-Deployment" />
<Folder Include="Scripts\Post-Deployment" />
<Folder Include="Data Generation Plans" />
<Folder Include="Schema Comparisons" />
<Folder Include="Properties\" />
<Folder Include="Schema Objects\" />
<Folder Include="Schema Objects\Schemas\" />
<Folder Include="Schema Objects\Schemas\dbo\" />
<Folder Include="Schema Objects\Schemas\dbo\Programmability\" />
<Folder Include="Schema Objects\Schemas\dbo\Programmability\Defaults\" />
<Folder Include="Schema Objects\Schemas\dbo\Programmability\Functions\" />
<Folder Include="Schema Objects\Schemas\dbo\Programmability\Rules\" />
<Folder Include="Schema Objects\Schemas\dbo\Programmability\Stored Procedures\" />
<Folder Include="Schema Objects\Schemas\dbo\Programmability\Types\" />
<Folder Include="Schema Objects\Schemas\dbo\Programmability\Types\User Defined Data Types\" />
<Folder Include="Schema Objects\Schemas\dbo\Programmability\Types\User Defined Types CLR\" />
<Folder Include="Schema Objects\Schemas\dbo\Programmability\Types\User Defined Table Types\" />
<Folder Include="Schema Objects\Schemas\dbo\Programmability\Types\XML Schema Collections\" />
<Folder Include="Schema Objects\Schemas\dbo\Service Broker\" />
<Folder Include="Schema Objects\Schemas\dbo\Service Broker\Queues\" />
<Folder Include="Schema Objects\Schemas\dbo\Synonyms\" />
<Folder Include="Schema Objects\Schemas\dbo\Tables\" />
<Folder Include="Schema Objects\Schemas\dbo\Tables\Constraints\" />
<Folder Include="Schema Objects\Schemas\dbo\Tables\Indexes\" />
<Folder Include="Schema Objects\Schemas\dbo\Tables\Keys\" />
<Folder Include="Schema Objects\Schemas\dbo\Tables\Triggers\" />
<Folder Include="Schema Objects\Schemas\dbo\Tables\Statistics\" />
<Folder Include="Schema Objects\Schemas\dbo\Views\" />
<Folder Include="Schema Objects\Schemas\dbo\Views\Indexes\" />
<Folder Include="Schema Objects\Schemas\dbo\Views\Triggers\" />
<Folder Include="Schema Objects\Schemas\dbo\Views\Statistics\" />
<Folder Include="Schema Objects\Database Level Objects\" />
<Folder Include="Schema Objects\Database Level Objects\Assemblies\" />
<Folder Include="Schema Objects\Database Level Objects\Database Triggers\" />
<Folder Include="Schema Objects\Database Level Objects\Security\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Schemas\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Users\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Certificates\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Asymmetric Keys\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Master Keys\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Signatures\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Symmetric Keys\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Database Encryption Keys\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Database Audit Specification\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Roles\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Roles\Application Roles\" />
<Folder Include="Schema Objects\Database Level Objects\Security\Roles\Database Roles\" />
<Folder Include="Schema Objects\Database Level Objects\Service Broker\" />
<Folder Include="Schema Objects\Database Level Objects\Service Broker\Broker Priorities\" />
<Folder Include="Schema Objects\Database Level Objects\Service Broker\Contracts\" />
<Folder Include="Schema Objects\Database Level Objects\Service Broker\Event Notifications\" />
<Folder Include="Schema Objects\Database Level Objects\Service Broker\Message Types\" />
<Folder Include="Schema Objects\Database Level Objects\Service Broker\Remote Service Binding\" />
<Folder Include="Schema Objects\Database Level Objects\Service Broker\Routes\" />
<Folder Include="Schema Objects\Database Level Objects\Service Broker\Services\" />
<Folder Include="Schema Objects\Database Level Objects\Storage\" />
<Folder Include="Schema Objects\Database Level Objects\Storage\Full Text Stoplists\" />
<Folder Include="Schema Objects\Database Level Objects\Storage\Filegroups\" />
<Folder Include="Schema Objects\Database Level Objects\Storage\Files\" />
<Folder Include="Schema Objects\Database Level Objects\Storage\Full Text Catalogs\" />
<Folder Include="Schema Objects\Database Level Objects\Storage\Partition Functions\" />
<Folder Include="Schema Objects\Database Level Objects\Storage\Partition Schemes\" />
</ItemGroup>
<ItemGroup>
<PropertiesFile Include="Properties\Database.sqlsettings">
</PropertiesFile>
<PropertiesFile Include="Properties\Database.sqldeployment">
</PropertiesFile>
<PropertiesFile Include="Properties\Database.sqlcmdvars">
</PropertiesFile>
<Build Include="Properties\Database.sqlpermissions">
<ModelBuilderType>Permissions</ModelBuilderType>
</Build>
<PreDeploy Include="Scripts\Pre-Deployment\Script.PreDeployment.sql">
<SubType>Code</SubType>
</PreDeploy>
<PostDeploy Include="Scripts\Post-Deployment\Script.PostDeployment.sql">
<SubType>Code</SubType>
</PostDeploy>
</ItemGroup>
<ItemGroup>
<BuildContributorArgument Include="OutDir=$(OutDir)" />
</ItemGroup>
<ItemGroup>
<NotInBuild Include="Scripts\fed-all.sql">
<SubType>NotInBuild</SubType>
</NotInBuild>
</ItemGroup>
</Project>