MS Project Download
: :
?

[86]

[28]

[60]

[63]

[129]

[26]

[54]

[4]

[38]

MS Project . [4]

Microsoft Project [3]

MS Project Server [36]

Microsoft Project [5]


08.01.2004
Kacep MS SQL 2000 Project Central Server

Kacep MS SQL Web-poe acaa pep -
Microsoft Project Server 

O e a ca?

ooae: 3ae ye acep? pep acepoo pee Project Server

IT-Meeepy: e xopo ox acep MS SQL?

Papaoy: Ka acapoa MS Project Server acep MS SQL? 

Bo


O e a ca?

aa ca ocea coa acppoa poe acaa pep. eec y coae cce, oopx eppoa eoe eoe  ecoo cepepo ooo poe, coae a aaex acepo. M ye aapoa cpeca acapoa Microsoft SQL Server ,  o eca TPC-C  o ca cp acep pe. M ye paccapa a c oo acepoo exaa acapyec  peaoe poee, ao cyae Web-cepep poeo MS Project  Server . o Web-poee peaaeoe poeoo ypae yea peax apa paoeo pee. B ae aae paccop peae ococa eoca acepx pee a ae MS SQL Server .

ooae: 3ae ye acep? pep acepoo pee Project  Server

o acepa pae pooe oa ecoo pae oxo, a "ycpeeoe" opeeee acepa.

Kacep - o oeee ecox cepepo ey ccey. 

Oo acepoe peee pe ceyx ee:

  • oee pooeoc (ecoo cepepo opaaa ae oopeeo)
  • epa cex a ax ey ccey (oyee ocopoao oeoc)
  • oea aa ax (oee cepepa acepe oy e o py o pya)
  • oee aeoc (ac cepepo acepe pae po ypyx)

Paccop pep.  eec oa "Poa Koa", eo xo a opaee "Poa" "Koa". Oa opaee poeoo ypae yea paoeo pee coy co MS Project  Server. Bce xopoo, o peyec oy ocopoay oeoc o paoe oox opaee. oo coaec cea cepep oeo, oop ae acep cepepa oeo. pe cepepa oeo e pao ap ocy ac opa a cepepy pyoo oea, a cepepy ocopoao oeoc. 3aaa cop ax "Poa Koa" oe ayaa, .. oa cpo epepacae  ooe xoa ye opa ae coceee opaeee pae e eae.

poo pe "Poa Koa" aeo poc. Bopoc peoa pooeoc cce. Kpoe oo, ooc eae eppoa ec oyeooopo ypae ey opaee, p o oca cope poeo cac paax oeo. Coaec o cepep oyeooopoa Project , a cepepa c poea ocac  paax oeo. Bc ccea oeec eoe eoe epe acep.

IT-Meeepy: e xopo ox acep MS SQL ?

M oca e acepoe peee xapaepoe MS SQL . Ocae acepx exoo Microsoft oo ae ocope a ceao cpae.

Kae ococa ec y acepa oa Microsoft?

  • Oe coa pooeoc, o MS SQL ceac po ep a aope Windows NT/ (ep poa a ao aope ep o eca TPC cpae co ce aopa).
  • Kacep MS SQL oo coaa o epe eoxooc epa oex cepepo, e eoxooc cpay ayca opoy acepy ccey. o a aaea oe "ay o epe poca".
  • Mopoae acepo MS SQL , a pao, oe pocoe, eoe eeoe peee. o coooe pooeoc/ea acep MS SQL  ec epo.
  • Kacep MS SQL  oy eepoe, .e. oe cae pae cepepa. o oe yaoe peee acepo ox c e oye ocopoa oeoc. Hapep, acep MS SQL  oe a cepepa MS SQL 7.0 Oracle. Oao eepoee acep eeee paoa ooex acepo MS SQL  opae o oooc ooe ax.
  • Kacep MS SQL oo cea ay ax cepepo acepe py o pya, o oe ao peex a B2B (bussiness to bussiness)

Kae eoca ec y acepa MS SQL ?

  • o poee paoao acepe MS SQL  oo oo ceao cpoepoao. Ec ypoeo,  poee oo ye xpa co ae pax cepepax. pepo aoo poe ec MS Project  Server. B yeee oo caa, o o ox cyax epeea o acep ocaoo poca, o oo cpe cepee poe (c. e).
  • Cece peyeo ya. Coae acepa MS SQL  e ec co acpa yce, .e. eocaoo poco oo ay acep.
  • poee xopoo opoaoe acepo MS SQL  oe e paoa a pyx SQL-cepepax, apep a Oracle. Cepep Project  cpoepoa a, o o oe e epeeo yopoa o Oracle, o o ec coo eoopx cooce coa acepa MS SQL  (c. e).
  • Kacep MS SQL  oe opaoa ae aa papao, oao, o oy o eo oaey coy pooeoc opeyec ocaoo apoa poeccoa.
  • Kacep MS SQL , oop ocyae, e ec aapo-yco ca o cee. aapo ycooc a opeyec paepy apaeo Failover Cluster (opoee y). o copee aeae, e eocao.

 

Papaoy: Ka acapoa MS Project  acep MS SQL ? 

M oe a opaoa pocoe acepoe peee Microsoft Project  a 3-5 eoeo-e. aoe peee ee cyecee opae o yoaoc. M e ye paccapa oee coe acepe pee, ae a acepa a workflow (c. e), ae pee eee aaa. Ec a y coe acepe pee e a ivanov-soft@inbox.ru

pee ceo o apxeype MS Project Server . Cepep cpoepoa a, o paoa acepe MS SQL . B ocoo o aaec o, o  cocoe xpa ae o poea pax aax ax, cyecye oo oa ea aa ax   - o aa poeoo oyeooopoa cepepa.  Pao eca ooaee ec payep, c ec-oa peaoaa e ActiveX COM ooe. MS Project  poy c opo apxeypo, .e. oee eo opoa. 

Ececeo apaae peee, o   ocpoe a disributed view, o o e a.  eo o, o Microsoft cpec, o  o paoa o Oracle. a aaa a ae epeoea. aec  oe paoa a o SQL cepepe, o a opeyec acpo ec cea co y eepa e. 

ea cay a ooaopeoc Microsoft pe e  cooa pee  "for MS SQL only", ooy eaoe ay eac ca  Server, ax cpec oyeooopoa oeoc o paoae ocaoo eo. Oao ec ecoo p o oop eecoopao ayc acep MS SQL :

1) Ec xoe cpo ocopoae oe coy OLAP Data Mining, o coae acepa MS SQL  eca eecoopao, .. o ypoc ocy opa oc copoc oppoa oeo.
2) pya pa o acepa, ooo yee papaaa pacpe Microsoft Project , apep aoaec ca oe poxoe oa poe eeepo. B ao cyae acep oo a aeo ypoc papaoy o pooeoc cce.
3) Booo xoe oc pooeoc  ayc acep, o o ee cc oya ec y ac oee 100 ooaee. Taoe oeco ae oe apa oe eo, ec  coyec copa cac o peax apaax paoeo pee. B ao cyae timesheet ye ao a copy oa. ox opopa cop ooo cac caap.

o yo cea opaa acepa poex a?

1) Coae aax aaxc c MSP ceaoe oe, oopoe ye pa po "partitioning column". Hapep, eoe oe BaseId - eaop a (oo ee cooa o a "eapae" ..)
2) caoe o aee o yoa cooecyee  .

3) Coae a MSP-aax , a BaseId a ac.

4) Haoe a oe BaseId opaee  (check) cooecyee .

5) Coae distributed view epe ce a

Bo pae cpo aece cpa:

CREATE TABLE [dbo].[MSP_ASSIGNMENTS] (
[PROJ_ID] [int] NOT NULL ,
[ASSN_UID] [int] NOT NULL ,
[BaseId] [int] NOT NULL

....... 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[MSP_ASSIGNMENTS] WITH NOCHECK ADD 
CONSTRAINT [PK__MSP_ASSIGNMENTS__29221CFB] PRIMARY KEY CLUSTERED 
(
[ASSN_UID],
[PROJ_ID],
[BaseId]
) WITH FILLFACTOR = 40 ON [PRIMARY] 
GO

ALTER TABLE [dbo].[MSP_ASSIGNMENTS] WITH NOCHECK ADD 

.....
CONSTRAINT [DF_MSP_ASSIGNMENTS_BaseId] DEFAULT (1) FOR [BaseId],
CONSTRAINT [CK_MSP_ASSIGNMENTS] CHECK ([BaseId] = 1)
GO

CREATE VIEW ASSIGNMENTS AS
SELECT * from Server1.PrjBase1.dbo.MSP_ASSIGNMENTS
UNION ALL

SELECT * from Server2.PrjBase2.dbo.MSP_ASSIGNMENTS
.....

 

ece poe acepx pee o MS Project  Server:

pee ceo peoey oaoc c opae a acep

1) Peoey oce cex ay epecoa constraints a aax, ae distributed view oe e oa ooy BaseId (opooc MSDN).

2) poepe Query Plan cox apoco, apocax e join oaop oe e oa BaseId aa capoa ce a acepa. Ceae join a o aae primary key, yae x ocae ae, ceae pepo ay aecy ocpy select * from DistributedView where BaseId=XXX and ((Key1=0) and (Key2=0) or (Key1>0 and Key2>0)). B pe ec MS ceae ceae x xaa apoo oo, o a eoxooc oae. Booe xoec oxa Microsoft, cox apocax c o oeco ce distributed view  a pao opyec pao eca eo.

3) Opae ae, o ae poco pepe e e coee cea insert disributed view, .. ec default-oo. 3ao e epeeo MS Project ye e poe a ca ay. cae oeo o oae (update) o e cyeceo, pyx aa yo pe oee cooe peee.

4) ooo e poco paec o acepy ay oyeooopoa ooo cepepa Microsoft Project , .. a a aax co indentity-yepaop, x e cooa updatable distributed view. o ayc acep a opeyec cea co y eepa a, e aye ca ee o oe a Qylibstd.sql apoc oep 13000. B eo o xpoe peee, oe oeoe, ec a oo cepepe  oe 200 ooaee. Ec oo a peyec e a ivanov-soft@inbox.ru

5) Moo pe cey poco pe coa acepa a oyeooopoa Project , o c opae: e oee 100-200 ooaee a cepep e peyec ec workflow ey cepepa. caoe ecoo cepepo Project . x epa epeee cex ooaee a NT-cepeoc,  ae coae  acep oye ocopoao cac o eye aae aaa (Assignments reports).  Tao oxo oo paoae, o e aae epoec pe cpeca apxpoa  (c. e Admin - Delete from database). 

6) aa coe: e ycaaae MS SQL IIS   a o cepep, ec ooc eo eea..

 

Bo

MS Project  Server  oo epx poe ocyx ae a oa a pe, oopoe ee oooc cooa acepe exa MS SQL Server .  ee ee eoope opae opaa acepoo pee. Ha pepe Microsoft Project  Server oo yec coo pooeoc acepa MS SQL . 

MicrosoftProject.ru.
"" .
, ,
.
, .

,
.
:

, , Ctrl+Enter. !

© 2003-2017, MicrosoftProject.Ru. .

E-mail: