Egalware/C2P
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
C2P/C2P_Project/C2P_DB.sqlproj
T
Samuele E. Locatelli 46cbe95788 Riconf x corretto deploy reports nei vari targets
2014-11-21 19:02:13 +01:00

340 lines
19 KiB
XML
Raw Permalink Blame History

<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">
<PropertyGroup>
<VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">10.0</VisualStudioVersion>
<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)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
<PropertyGroup>
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
<Name>C2P_DB</Name>
<SchemaVersion>2.0</SchemaVersion>
<ProjectVersion>4.1</ProjectVersion>
<ProjectGuid>{84db66e4-9663-47f7-9dd1-3cb562629ff5}</ProjectGuid>
<DSP>Microsoft.Data.Tools.Schema.Sql.Sql100DatabaseSchemaProvider</DSP>
<OutputType>Database</OutputType>
<RootPath>
</RootPath>
<RootNamespace>C2P_Project</RootNamespace>
<AssemblyName>C2P_Project</AssemblyName>
<ModelCollation>1033,CI</ModelCollation>
<DefaultFileStructure>BySchemaAndSchemaType</DefaultFileStructure>
<DeployToDatabase>True</DeployToDatabase>
<TargetFrameworkVersion>v4.5</TargetFrameworkVersion>
<TargetLanguage>CS</TargetLanguage>
<AppDesignerFolder>Properties</AppDesignerFolder>
<SqlServerVerification>False</SqlServerVerification>
<TargetDatabaseSet>True</TargetDatabaseSet>
<DefaultCollation>SQL_Latin1_General_CP1_CI_AS</DefaultCollation>
<DefaultFilegroup>PRIMARY</DefaultFilegroup>
<GenerateCreateScript>True</GenerateCreateScript>
<IncludeSchemaNameInFileName>True</IncludeSchemaNameInFileName>
</PropertyGroup>
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
<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 />
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'DEMO|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)' == 'deploy|AnyCPU' ">
<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)' == 'IIS02|AnyCPU' ">
<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>
<Import Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
<ItemGroup>
<Folder Include="Properties" />
<Folder Include="tmp\" />
<Folder Include="tmp\Tables\" />
<Folder Include="dbo\" />
<Folder Include="dbo\Tables\" />
<Folder Include="ext\" />
<Folder Include="ext\Tables\" />
<Folder Include="dbo\Views\" />
<Folder Include="dbo\Functions\" />
<Folder Include="ext\Stored Procedures\" />
<Folder Include="dbo\Stored Procedures\" />
<Folder Include="tmp\Stored Procedures\" />
<Folder Include="voc\" />
<Folder Include="voc\Stored Procedures\" />
<Folder Include="Security\" />
<Folder Include="Snapshots" />
<Folder Include="ext\Views\" />
</ItemGroup>
<ItemGroup>
<Build Include="tmp\Tables\ProductionLogRaw_KO.sql" />
<Build Include="dbo\Tables\Package2ItemClient.sql" />
<Build Include="dbo\Tables\ProductionLog.sql" />
<Build Include="ext\Tables\ProductionLogRaw_KO.sql" />
<Build Include="ext\Tables\ProductionLogRaw.sql" />
<Build Include="dbo\Tables\QuoteFull_Q_old.sql" />
<Build Include="dbo\Tables\Package2Item.sql" />
<Build Include="dbo\Tables\QuoteList.sql" />
<Build Include="dbo\Tables\QuoteWorkExt.sql" />
<Build Include="dbo\Tables\QuoteWorkInt.sql" />
<Build Include="dbo\Tables\QuoteOC.sql" />
<Build Include="dbo\Tables\Config.sql" />
<Build Include="dbo\Tables\QuoteFull_Q.sql" />
<Build Include="dbo\Tables\QuoteParam.sql" />
<Build Include="tmp\Tables\DiesRaw.sql" />
<Build Include="ext\Tables\ClientsRaw.sql" />
<Build Include="dbo\Tables\Lingue.sql" />
<Build Include="dbo\Tables\Vocabolario.sql" />
<Build Include="ext\Tables\TranspCostRaw.sql" />
<Build Include="tmp\Tables\ProductionLogRaw_old.sql" />
<Build Include="ext\Tables\DiesRaw.sql" />
<Build Include="dbo\Tables\TabDifett.sql" />
<Build Include="tmp\Tables\ExcludeCondFilter.sql" />
<Build Include="tmp\Tables\DiesGroupRaw.sql" />
<Build Include="dbo\Tables\ItemDet.sql" />
<Build Include="dbo\Tables\QuoteRM.sql" />
<Build Include="tmp\Tables\TranspCostRaw.sql" />
<Build Include="dbo\Tables\TranspCostDet.sql" />
<Build Include="dbo\Tables\Incoterms.sql" />
<Build Include="tmp\Tables\ItemsRaw.sql" />
<Build Include="ext\Tables\ItemsRaw.sql" />
<Build Include="dbo\Tables\DiesDet.sql" />
<Build Include="dbo\Tables\Utilities.sql" />
<Build Include="dbo\Tables\AgentsDet.sql" />
<Build Include="tmp\Tables\ClientsRaw.sql" />
<Build Include="dbo\Tables\ClientDet.sql" />
<Build Include="dbo\Tables\TabProdSc.sql" />
<Build Include="dbo\Tables\Cost2Plant.sql" />
<Build Include="dbo\Tables\DiesGroupDet.sql" />
<Build Include="dbo\Tables\RevHistory.sql" />
<Build Include="dbo\Tables\PlantsDet.sql" />
<Build Include="dbo\Tables\TabImbArt.sql" />
<Build Include="dbo\Tables\PackagDet.sql" />
<Build Include="ext\Tables\DiesGroupRaw.sql" />
<Build Include="tmp\Tables\PackagRaw.sql" />
<Build Include="dbo\Tables\TabImbGrp.sql" />
<Build Include="ext\Tables\PackagRaw.sql" />
<Build Include="dbo\Tables\RawMatDet.sql" />
<Build Include="tmp\Tables\ProductionLogRaw.sql" />
<Build Include="dbo\Tables\Package2.sql" />
<Build Include="dbo\Views\v_QuoteFull_Q.sql" />
<Build Include="dbo\Views\v_selClient.sql" />
<Build Include="dbo\Views\v_selItems.sql" />
<Build Include="dbo\Functions\f_getCodPackag_OLD.sql" />
<Build Include="dbo\Functions\f_trim.sql" />
<Build Include="dbo\Functions\f_dtFromRaw.sql" />
<Build Include="dbo\Functions\f_getSubstring.sql" />
<Build Include="dbo\Functions\f_getDataCodPackag.sql" />
<Build Include="ext\Stored Procedures\stp_mergePackage2Item.sql" />
<Build Include="ext\Stored Procedures\stp_mergePackage2ItemClient.sql" />
<Build Include="dbo\Stored Procedures\stp_QL_update.sql" />
<Build Include="tmp\Stored Procedures\importItemsRaw.sql" />
<Build Include="dbo\Stored Procedures\stp_QL_fullData.sql" />
<Build Include="tmp\Stored Procedures\importClientsRaw.sql" />
<Build Include="dbo\Stored Procedures\stp_packageCost.sql" />
<Build Include="dbo\Stored Procedures\stp_QL_update_30_01.sql" />
<Build Include="dbo\Stored Procedures\stp_zzz_scratch.sql" />
<Build Include="dbo\Stored Procedures\stp_QL_fullDataAll.sql" />
<Build Include="dbo\Stored Procedures\stp_QL_update_07_02.sql" />
<Build Include="dbo\Stored Procedures\stp_QuoteFull_Q_update.sql" />
<Build Include="dbo\Stored Procedures\stp_VSCli_SearchLike.sql" />
<Build Include="dbo\Stored Procedures\stp_QL_fullDataSearch.sql" />
<Build Include="tmp\Stored Procedures\convertItemsRaw.sql" />
<Build Include="tmp\Stored Procedures\importDiesRaw.sql" />
<Build Include="tmp\Stored Procedures\convertClientsRaw.sql" />
<Build Include="ext\Stored Procedures\stp_mergeTranspCostDet.sql" />
<Build Include="tmp\Stored Procedures\convertDiesRaw.sql" />
<Build Include="dbo\Stored Procedures\stp_VSItem_SearchLike.sql" />
<Build Include="ext\Stored Procedures\stp_mergeDiesDet.sql" />
<Build Include="ext\Stored Procedures\stp_mergeClientDet.sql" />
<Build Include="dbo\Stored Procedures\stp_esplodiVocab.sql" />
<Build Include="dbo\Stored Procedures\stp_TD_upsert.sql" />
<Build Include="ext\Stored Procedures\stp_mergeItemDet.sql" />
<Build Include="voc\Stored Procedures\stp_insNewLemma.sql" />
<Build Include="tmp\Stored Procedures\importTranspCostRaw.sql" />
<Build Include="tmp\Stored Procedures\importDiesGroupRaw.sql" />
<Build Include="tmp\Stored Procedures\convertTranspCostRaw.sql" />
<Build Include="ext\Stored Procedures\stp_mergeRawMat.sql" />
<Build Include="tmp\Stored Procedures\importProductionLogRaw.sql" />
<Build Include="ext\Stored Procedures\stp_updateProductionLog.sql" />
<Build Include="ext\Stored Procedures\stp_mergeAgentsDet.sql" />
<Build Include="tmp\Stored Procedures\convertProductionLogRaw.sql" />
<Build Include="tmp\Stored Procedures\importPackagRaw.sql" />
<Build Include="dbo\Stored Procedures\stp_TI_upsert.sql" />
<Build Include="tmp\Stored Procedures\convertPackagRaw.sql" />
<Build Include="dbo\Stored Procedures\stp_TPS_upsert.sql" />
<Build Include="ext\Stored Procedures\stp_mergePlantsDet.sql" />
<Build Include="tmp\Stored Procedures\convertDiesGroupRaw.sql" />
<Build Include="dbo\Stored Procedures\stp_QL_update_SAM.sql" />
<Build Include="ext\Stored Procedures\stp_mergeCost2Plant.sql" />
<Build Include="ext\Stored Procedures\stp_mergeDiesGroupDet.sql" />
<Build Include="ext\Stored Procedures\stp_mergePackagDet.sql" />
<Build Include="dbo\Stored Procedures\stp_QL_fullDataUpdate.sql" />
<Build Include="ext\Stored Procedures\stp_filterProductionLogRow.sql" />
<Build Include="ext\Stored Procedures\stp_mergePackage2.sql" />
<Build Include="Security\ext.sql" />
<Build Include="Security\tmp.sql" />
<Build Include="Security\voc.sql" />
<Build Include="ext\Stored Procedures\ext.stp_mergePackage2ItemClient_OLD.sql" />
<Build Include="ext\Stored Procedures\ext.stp_mergePackage2Item_OLD.sql" />
<Build Include="ext\Stored Procedures\ext.stp_mergePackage2_OLD.sql" />
<Build Include="dbo\Views\dbo.v_selRawMat.sql" />
<Build Include="dbo\Views\dbo.v_selCons.sql" />
<Build Include="dbo\Functions\dbo.f_padRight.sql" />
<Build Include="dbo\Functions\dbo.f_padLeft.sql" />
<Build Include="dbo\Functions\dbo.f_getNewCodQuote.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_VSRM_SearchLike.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QuoteFull_delete.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QRM_getByKey.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QL_insNew.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QL_getByKey.sql" />
<Build Include="dbo\Views\dbo.v_selIncoterms.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_test.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLF_UpdHead.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLF_UpdCosts.sql" />
<Build Include="dbo\Tables\dbo.Permessi2Funzione.sql" />
<Build Include="dbo\Tables\dbo.Permessi.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLF_UpdQState.sql" />
<Build Include="tmp\Tables\tmp.OrdersHistRaw.sql" />
<Build Include="ext\Tables\ext.OrdersHistRaw.sql" />
<Build Include="dbo\Tables\dbo.UTENTE.sql" />
<Build Include="dbo\Tables\dbo.TrascPlan.sql" />
<Build Include="dbo\Tables\dbo.TrascItem.sql" />
<Build Include="dbo\Tables\dbo.TrascDies.sql" />
<Build Include="dbo\Tables\dbo.TrascClient.sql" />
<Build Include="dbo\Tables\dbo.TrascClass03.sql" />
<Build Include="dbo\Tables\dbo.TrascClass02.sql" />
<Build Include="dbo\Tables\dbo.TrascClass01.sql" />
<Build Include="dbo\Tables\dbo.ReportPrintTicket.sql" />
<Build Include="dbo\Tables\dbo.QuoteSimPar.sql" />
<Build Include="dbo\Tables\dbo.QuoteFull_S.sql" />
<Build Include="dbo\Tables\dbo.QuoteFull_R.sql" />
<Build Include="dbo\Tables\dbo.QuoteFull_C.sql" />
<Build Include="dbo\Tables\dbo.PickList.sql" />
<Build Include="dbo\Tables\dbo.OrdersHist.sql" />
<Build Include="dbo\Tables\dbo.MODULO.sql" />
<Build Include="dbo\Tables\dbo.FUNZIONE.sql" />
<Build Include="dbo\Tables\dbo.DIRITTI.sql" />
<Build Include="dbo\Tables\dbo.CostList.sql" />
<Build Include="dbo\Tables\dbo.ContatoriQuote.sql" />
<Build Include="dbo\Tables\dbo.CDC.sql" />
<Build Include="dbo\Views\dbo.v_StdCostList.sql" />
<Build Include="dbo\Views\dbo.v_selPlant.sql" />
<Build Include="dbo\Views\dbo.v_selPackage.sql" />
<Build Include="dbo\Views\dbo.v_selDateStdCost.sql" />
<Build Include="dbo\Views\dbo.v_pivot.sql" />
<Build Include="dbo\Views\dbo.v_MarginReportStatsNewData.sql" />
<Build Include="dbo\Views\dbo.v_MarginReportStats.sql" />
<Build Include="dbo\Views\dbo.v_listinoArticoli.sql" />
<Build Include="dbo\Functions\dbo.fnFormatDate.sql" />
<Build Include="dbo\Functions\dbo.f_prt_getParameter.sql" />
<Build Include="voc\Stored Procedures\voc.stp_voUpdateLemmiReport.sql" />
<Build Include="voc\Stored Procedures\voc.stp_upsertLemma.sql" />
<Build Include="voc\Stored Procedures\voc.stp_updateQuery.sql" />
<Build Include="voc\Stored Procedures\voc.stp_getByLinguaLemmaLike.sql" />
<Build Include="voc\Stored Procedures\voc.stp_getByLingua.sql" />
<Build Include="tmp\Stored Procedures\tmp.importOrdersHistRaw.sql" />
<Build Include="tmp\Stored Procedures\tmp.convertOrdersHistRaw.sql" />
<Build Include="ext\Stored Procedures\ext.stp_mergeOrdersHist.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_zzz_scratchDatiDemo.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_SC2C_insertForDate.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_SC2C_deleteForDate.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_SC2C_countRemaining.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_RPT_reserveTicket.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_RPT_insertNew.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_RMD_getByKey.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QSP_upsert.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLS_UpdPackPar.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLS_UpdHead.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLS_UpdExtrPar.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLS_UpdDiesPar.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLR_insNew.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLR_getByDate.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLF_revHist.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLF_Insert.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLF_getMinMax.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLF_getLast.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLC_insNew_OLD.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLC_insNew.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QL_newRev.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QL_makeSim.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QL_fullDataCount.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QL_delete.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QL_clone.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QFC_creaListino.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_prt_dsQuoteFull_Q_Data.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_prt_dsQuoteFull_byChiave.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_PL_getByListLingua.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_OH_countRemaining.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_getDataCodPackag.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_checkOffers4Item.sql" />
<Build Include="ext\Tables\ext.RcdPlants.sql" />
<Build Include="ext\Tables\ext.RcdPackage.sql" />
<Build Include="ext\Tables\ext.RcdItem.sql" />
<Build Include="ext\Tables\ext.RcdClient.sql" />
<Build Include="ext\Tables\ext.RcdClass02.sql" />
<Build Include="ext\Tables\ext.RcdClass01.sql" />
<Build Include="dbo\Tables\dbo.ListValues.sql" />
<Build Include="ext\Views\ext.v_MarginReportRcd.sql" />
<Build Include="ext\Views\ext.v_ItemDetRcd.sql" />
<Build Include="ext\Views\ext.v_ClientDetRcd.sql" />
<Build Include="dbo\Views\dbo.v_selListVal.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QLF_Delete.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_listValues_getValidValuesFilt.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_listValues_getValidValues.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_listValues_getByTable.sql" />
<Build Include="dbo\Views\dbo.v_MarginReport.sql" />
<Build Include="dbo\Stored Procedures\dbo.stp_QL_copyParamS.sql" />
</ItemGroup>
<ItemGroup>
<None Include="SchemaComp_C2P_Data.scmp" />
<None Include="C2P_Project.publish.xml" />
<None Include="Snapshots\C2P_Project_orig.dacpac" />
<None Include="Snapshots\C2P_DB_20140224_15-48-32.dacpac" />
<None Include="Compare Proxima_C2P vs C2P_DB.scmp" />
<None Include="Snapshots\C2P_DB_20140416_10-42-42.dacpac" />
<None Include="SchemaComp_C2P.scmp" />
<None Include="DataComp_C2P_Data.dcmp" />
</ItemGroup>
</Project>
Reference in New Issue View Git Blame Copy Permalink