SSDTt4Helper.sqlproj

<?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>SSDTt4Helper</Name>
    <SchemaVersion>2.0</SchemaVersion>
    <ProjectVersion>4.1</ProjectVersion>
    <ProjectGuid>{a0b598ee-777b-4f6b-812d-2f8c1c34ddf0}</ProjectGuid>
    <DSP>Microsoft.Data.Tools.Schema.Sql.Sql140DatabaseSchemaProvider</DSP>
    <OutputType>Database</OutputType>
    <RootPath>
    </RootPath>
    <RootNamespace>SSDTt4Helper</RootNamespace>
    <AssemblyName>SSDTt4Helper</AssemblyName>
    <ModelCollation>1033,CI</ModelCollation>
    <DefaultFileStructure>BySchemaAndSchemaType</DefaultFileStructure>
    <DeployToDatabase>True</DeployToDatabase>
    <TargetFrameworkVersion>v4.5.2</TargetFrameworkVersion>
    <TargetLanguage>CS</TargetLanguage>
    <AppDesignerFolder>Properties</AppDesignerFolder>
    <SqlServerVerification>False</SqlServerVerification>
    <IncludeCompositeObjects>True</IncludeCompositeObjects>
    <TargetDatabaseSet>True</TargetDatabaseSet>
    <DefaultCollation>SQL_Latin1_General_CP1_CI_AS</DefaultCollation>
    <DefaultFilegroup>PRIMARY</DefaultFilegroup>
  </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="'$(SQLDBExtensionsRefPath)' != ''" Project="$(SQLDBExtensionsRefPath)\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
  <Import Condition="'$(SQLDBExtensionsRefPath)' == ''" Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
  <ItemGroup>
    <Folder Include="Properties" />
    <Folder Include="Production\" />
    <Folder Include="Production\Tables\" />
    <Folder Include="HumanResources\" />
    <Folder Include="HumanResources\Tables\" />
    <Folder Include="Purchasing\" />
    <Folder Include="Purchasing\Tables\" />
    <Folder Include="Sales\" />
    <Folder Include="Sales\Tables\" />
    <Folder Include="dbo\" />
    <Folder Include="dbo\Tables\" />
    <Folder Include="Person\" />
    <Folder Include="Person\Tables\" />
    <Folder Include="Sales\Views\" />
    <Folder Include="Purchasing\Views\" />
    <Folder Include="Person\Views\" />
    <Folder Include="HumanResources\Views\" />
    <Folder Include="Production\Views\" />
    <Folder Include="Storage\" />
    <Folder Include="dbo\Functions\" />
    <Folder Include="dbo\Stored Procedures\" />
    <Folder Include="HumanResources\Stored Procedures\" />
    <Folder Include="dbo\User Defined Types\" />
    <Folder Include="Security\" />
    <Folder Include="Person\XMLSchemaCollections\" />
    <Folder Include="HumanResources\XMLSchemaCollections\" />
    <Folder Include="Production\XMLSchemaCollections\" />
    <Folder Include="Sales\XMLSchemaCollections\" />
    <Folder Include="T4_CODE_GENERATION" />
    <Folder Include="T4_CODE_GENERATION\BASE" />
    <Folder Include="T4_CODE_GENERATION\Demo Polybase Generation" />
    <Folder Include="T4_CODE_GENERATION\Demo ServiceBroker Generation" />
    <Folder Include="T4_CODE_GENERATION\Auditing demo" />
    <Folder Include="Schemas" />
  </ItemGroup>
  <ItemGroup>
    <Build Include="Production\Tables\ScrapReason.sql" />
    <Build Include="HumanResources\Tables\Shift.sql" />
    <Build Include="Production\Tables\ProductCategory.sql" />
    <Build Include="Purchasing\Tables\ShipMethod.sql" />
    <Build Include="Production\Tables\ProductCostHistory.sql" />
    <Build Include="Production\Tables\ProductDescription.sql" />
    <Build Include="Sales\Tables\ShoppingCartItem.sql" />
    <Build Include="Production\Tables\ProductDocument.sql" />
    <Build Include="dbo\Tables\DatabaseLog.sql" />
    <Build Include="Production\Tables\ProductInventory.sql" />
    <Build Include="Sales\Tables\SpecialOffer.sql" />
    <Build Include="dbo\Tables\ErrorLog.sql" />
    <Build Include="Production\Tables\ProductListPriceHistory.sql" />
    <Build Include="Person\Tables\Address.sql" />
    <Build Include="Sales\Tables\SpecialOfferProduct.sql" />
    <Build Include="Production\Tables\ProductModel.sql" />
    <Build Include="Person\Tables\AddressType.sql" />
    <Build Include="Person\Tables\StateProvince.sql" />
    <Build Include="Production\Tables\ProductModelIllustration.sql" />
    <Build Include="dbo\Tables\AWBuildVersion.sql" />
    <Build Include="Production\Tables\ProductModelProductDescriptionCulture.sql" />
    <Build Include="Production\Tables\BillOfMaterials.sql" />
    <Build Include="Sales\Tables\Store.sql" />
    <Build Include="Production\Tables\ProductPhoto.sql" />
    <Build Include="Production\Tables\ProductProductPhoto.sql" />
    <Build Include="Production\Tables\TransactionHistory.sql" />
    <Build Include="Production\Tables\ProductReview.sql" />
    <Build Include="Person\Tables\BusinessEntity.sql" />
    <Build Include="Production\Tables\TransactionHistoryArchive.sql" />
    <Build Include="Production\Tables\ProductSubcategory.sql" />
    <Build Include="Person\Tables\BusinessEntityAddress.sql" />
    <Build Include="Purchasing\Tables\ProductVendor.sql" />
    <Build Include="Person\Tables\BusinessEntityContact.sql" />
    <Build Include="Production\Tables\UnitMeasure.sql" />
    <Build Include="Purchasing\Tables\Vendor.sql" />
    <Build Include="Person\Tables\ContactType.sql" />
    <Build Include="Sales\Tables\CountryRegionCurrency.sql" />
    <Build Include="Person\Tables\CountryRegion.sql" />
    <Build Include="Production\Tables\WorkOrder.sql" />
    <Build Include="Purchasing\Tables\PurchaseOrderDetail.sql" />
    <Build Include="Sales\Tables\CreditCard.sql" />
    <Build Include="Production\Tables\Culture.sql" />
    <Build Include="Production\Tables\WorkOrderRouting.sql" />
    <Build Include="Sales\Tables\Currency.sql" />
    <Build Include="Purchasing\Tables\PurchaseOrderHeader.sql" />
    <Build Include="Sales\Tables\CurrencyRate.sql" />
    <Build Include="Sales\Tables\Customer.sql" />
    <Build Include="HumanResources\Tables\Department.sql" />
    <Build Include="Production\Tables\Document.sql" />
    <Build Include="Sales\Tables\SalesOrderDetail.sql" />
    <Build Include="Person\Tables\EmailAddress.sql" />
    <Build Include="HumanResources\Tables\Employee.sql" />
    <Build Include="Sales\Tables\SalesOrderHeader.sql" />
    <Build Include="HumanResources\Tables\EmployeeDepartmentHistory.sql" />
    <Build Include="HumanResources\Tables\EmployeePayHistory.sql" />
    <Build Include="Sales\Tables\SalesOrderHeaderSalesReason.sql" />
    <Build Include="Sales\Tables\SalesPerson.sql" />
    <Build Include="Production\Tables\Illustration.sql" />
    <Build Include="HumanResources\Tables\JobCandidate.sql" />
    <Build Include="Production\Tables\Location.sql" />
    <Build Include="Person\Tables\Password.sql" />
    <Build Include="Sales\Tables\SalesPersonQuotaHistory.sql" />
    <Build Include="Person\Tables\Person.sql" />
    <Build Include="Sales\Tables\SalesReason.sql" />
    <Build Include="Sales\Tables\SalesTaxRate.sql" />
    <Build Include="Sales\Tables\PersonCreditCard.sql" />
    <Build Include="Person\Tables\PersonPhone.sql" />
    <Build Include="Sales\Tables\SalesTerritory.sql" />
    <Build Include="Person\Tables\PhoneNumberType.sql" />
    <Build Include="Production\Tables\Product.sql" />
    <Build Include="Sales\Tables\SalesTerritoryHistory.sql" />
    <Build Include="Sales\Views\vStoreWithContacts.sql" />
    <Build Include="Sales\Views\vStoreWithAddresses.sql" />
    <Build Include="Purchasing\Views\vVendorWithContacts.sql" />
    <Build Include="Purchasing\Views\vVendorWithAddresses.sql" />
    <Build Include="Sales\Views\vw_SalesOrders.sql" />
    <Build Include="Sales\Views\vw_SalesPerson.sql" />
    <Build Include="Person\Views\vAdditionalContactInfo.sql" />
    <Build Include="HumanResources\Views\vEmployee.sql" />
    <Build Include="HumanResources\Views\vEmployeeDepartment.sql" />
    <Build Include="HumanResources\Views\vEmployeeDepartmentHistory.sql" />
    <Build Include="Sales\Views\vIndividualCustomer.sql" />
    <Build Include="Sales\Views\vPersonDemographics.sql" />
    <Build Include="HumanResources\Views\vJobCandidate.sql" />
    <Build Include="HumanResources\Views\vJobCandidateEmployment.sql" />
    <Build Include="HumanResources\Views\vJobCandidateEducation.sql" />
    <Build Include="Production\Views\vProductAndDescription.sql" />
    <Build Include="Production\Views\vProductModelCatalogDescription.sql" />
    <Build Include="Production\Views\vProductModelInstructions.sql" />
    <Build Include="Sales\Views\vSalesPerson.sql" />
    <Build Include="Sales\Views\vSalesPersonSalesByFiscalYears.sql" />
    <Build Include="Person\Views\vStateProvinceCountryRegion.sql" />
    <Build Include="Sales\Views\vStoreWithDemographics.sql" />
    <Build Include="Storage\AW2014FullTextCatalog.sql" />
    <Build Include="FullTextIndexes.sql" />
    <Build Include="dbo\Functions\ufnGetAccountingStartDate.sql" />
    <Build Include="dbo\Functions\ufnGetAccountingEndDate.sql" />
    <Build Include="dbo\Functions\ufnGetProductDealerPrice.sql" />
    <Build Include="dbo\Functions\ufnGetProductListPrice.sql" />
    <Build Include="dbo\Functions\ufnGetProductStandardCost.sql" />
    <Build Include="dbo\Functions\ufnGetStock.sql" />
    <Build Include="dbo\Functions\ufnGetDocumentStatusText.sql" />
    <Build Include="dbo\Functions\ufnGetPurchaseOrderStatusText.sql" />
    <Build Include="dbo\Functions\ufnGetSalesOrderStatusText.sql" />
    <Build Include="dbo\Functions\ufnLeadingZeros.sql" />
    <Build Include="dbo\Functions\ufnGetContactInformation.sql" />
    <Build Include="dbo\Stored Procedures\uspGetBillOfMaterials.sql" />
    <Build Include="dbo\Stored Procedures\uspGetEmployeeManagers.sql" />
    <Build Include="dbo\Stored Procedures\uspGetManagerEmployees.sql" />
    <Build Include="dbo\Stored Procedures\uspGetWhereUsedProductID.sql" />
    <Build Include="HumanResources\Stored Procedures\uspUpdateEmployeeHireInfo.sql" />
    <Build Include="HumanResources\Stored Procedures\uspUpdateEmployeeLogin.sql" />
    <Build Include="dbo\Stored Procedures\uspPrintError.sql" />
    <Build Include="HumanResources\Stored Procedures\uspUpdateEmployeePersonalInfo.sql" />
    <Build Include="dbo\Stored Procedures\uspLogError.sql" />
    <Build Include="dbo\Stored Procedures\uspSearchCandidateResumes.sql" />
    <Build Include="dbo\Stored Procedures\RendimientoNoPredecible.sql" />
    <Build Include="dbo\User Defined Types\AccountNumber.sql" />
    <Build Include="dbo\User Defined Types\Flag.sql" />
    <Build Include="dbo\User Defined Types\NameStyle.sql" />
    <Build Include="dbo\User Defined Types\Name.sql" />
    <Build Include="dbo\User Defined Types\OrderNumber.sql" />
    <Build Include="dbo\User Defined Types\Phone.sql" />
    <Build Include="Security\HumanResources.sql" />
    <Build Include="Security\Person.sql" />
    <Build Include="Security\Production.sql" />
    <Build Include="Security\Purchasing_1.sql" />
    <Build Include="Security\Sales_1.sql" />
    <Build Include="Person\XMLSchemaCollections\AdditionalContactInfoSchemaCollection.sql" />
    <Build Include="HumanResources\XMLSchemaCollections\HRResumeSchemaCollection.sql" />
    <Build Include="Person\XMLSchemaCollections\IndividualSurveySchemaCollection.sql" />
    <Build Include="Production\XMLSchemaCollections\ManuInstructionsSchemaCollection.sql" />
    <Build Include="Production\XMLSchemaCollections\ProductDescriptionSchemaCollection.sql" />
    <Build Include="Sales\XMLSchemaCollections\StoreSurveySchemaCollection.sql" />
    <Build Include="ExtendedProperties.sql" />
    <Build Include="T4_CODE_GENERATION\BASE\InMemoryDatabaseModelIncludeSQLDW.sql">
      <DependentUpon>T4_CODE_GENERATION\BASE\InMemoryDatabaseModelIncludeSQLDW.tt</DependentUpon>
    </Build>
    <Build Include="Schemas\ServiceBroker.sql" />
    <Build Include="Schemas\History.sql" />
    <Build Include="Schemas\Auditing.sql" />
    <Build Include="dbo\Tables\master.sql" />
    <Build Include="dbo\Tables\slave.sql" />
  </ItemGroup>
  <ItemGroup>
    <None Include="T4_CODE_GENERATION\BASE\InMemoryDatabaseModelInclude.tt">
      <Generator>TextTemplatingFileGenerator</Generator>
    </None>
    <None Include="T4_CODE_GENERATION\BASE\InMemoryDatabaseModelIncludeSQLDW.tt">
      <Generator>TextTemplatingFileGenerator</Generator>
    </None>
    <None Include="T4_CODE_GENERATION\Demo Polybase Generation\CREATE_EXTERNAL_TABLES.tt">
      <Generator>TextTemplatingFileGenerator</Generator>
    </None>
    <None Include="T4_CODE_GENERATION\Demo Polybase Generation\LOAD_TABLES.tt">
      <Generator>TextTemplatingFileGenerator</Generator>
    </None>
    <None Include="T4_CODE_GENERATION\Auditing demo\AuditingTables.tt">
      <Generator>TextTemplatingFileGenerator</Generator>
    </None>
    <None Include="T4_CODE_GENERATION\Auditing demo\AuditingTriggers.tt">
      <Generator>TextTemplatingFileGenerator</Generator>
    </None>
    <None Include="T4_CODE_GENERATION\Auditing demo\HistoryTables.tt">
      <Generator>TextTemplatingFileGenerator</Generator>
    </None>
    <None Include="T4_CODE_GENERATION\Auditing demo\HistoryTriggers.tt">
      <Generator>TextTemplatingFileGenerator</Generator>
    </None>
    <None Include="T4_CODE_GENERATION\Auditing demo\TablesToProcess.json" />
    <None Include="T4_CODE_GENERATION\Demo ServiceBroker Generation\TablesToProcess.json" />
    <None Include="T4_CODE_GENERATION\Auditing demo\AuditingTables.dsql">
      <DependentUpon>T4_CODE_GENERATION\Auditing demo\AuditingTables.tt</DependentUpon>
    </None>
    <None Include="T4_CODE_GENERATION\Auditing demo\AuditingTriggers.dsql">
      <DependentUpon>T4_CODE_GENERATION\Auditing demo\AuditingTriggers.tt</DependentUpon>
    </None>
    <None Include="T4_CODE_GENERATION\BASE\InMemoryDatabaseModelIncludeServiceBroker.tt">
      <Generator>TextTemplatingFileGenerator</Generator>
    </None>
    <None Include="T4_CODE_GENERATION\Demo ServiceBroker Generation\create_datasync_triggers.tt">
      <Generator>TextTemplatingFileGenerator</Generator>
    </None>
    <None Include="T4_CODE_GENERATION\BASE\InMemoryDatabaseModelInclude.dsql">
      <DependentUpon>T4_CODE_GENERATION\BASE\InMemoryDatabaseModelInclude.tt</DependentUpon>
    </None>
    <None Include="T4_CODE_GENERATION\Demo ServiceBroker Generation\add_sync_columns_to_tables.dsql">
      <DependentUpon>T4_CODE_GENERATION\Demo ServiceBroker Generation\add_sync_columns_to_tables.tt</DependentUpon>
    </None>
    <None Include="T4_CODE_GENERATION\Demo ServiceBroker Generation\create_datasync_stored_procedures.dsql">
      <DependentUpon>T4_CODE_GENERATION\Demo ServiceBroker Generation\create_datasync_stored_procedures.tt</DependentUpon>
    </None>
    <None Include="T4_CODE_GENERATION\Demo Polybase Generation\CREATE_EXTERNAL_TABLES.dsql">
      <DependentUpon>T4_CODE_GENERATION\Demo Polybase Generation\CREATE_EXTERNAL_TABLES.tt</DependentUpon>
    </None>
    <None Include="T4_CODE_GENERATION\Demo Polybase Generation\LOAD_TABLES.dsql">
      <DependentUpon>T4_CODE_GENERATION\Demo Polybase Generation\LOAD_TABLES.tt</DependentUpon>
    </None>
    <None Include="T4_CODE_GENERATION\BASE\InMemoryDatabaseModelIncludeServiceBroker.dsql">
      <DependentUpon>T4_CODE_GENERATION\BASE\InMemoryDatabaseModelIncludeServiceBroker.tt</DependentUpon>
    </None>
    <None Include="T4_CODE_GENERATION\Demo ServiceBroker Generation\create_datasync_triggers.dsql">
      <DependentUpon>T4_CODE_GENERATION\Demo ServiceBroker Generation\create_datasync_triggers.tt</DependentUpon>
    </None>
  </ItemGroup>
</Project>