• Instalirati aplikaciju Space&Time sa zadanim komponentama, koje ponudi instalacijski program,
• Instalirati pripremljenu bazu podataka, koju spomenuta aplikacija upotrebljava (preporučljivo s imenom TSSPICA),
• Kreirati novi 'Login' sa zadanom bazom podataka TSSPICA (preporučljivo kreiranje istog preko aplikacije Enterprise Manager->New Login;)
• Pomoću Quary Analyzer se 'zakačimo' na bazu podataka, koju koristi aplikacija Pantheon (npr.: Datalab) i redom pokrenemo postupke pripremljene za prijenos podataka, tj. pokrenemo slijedeću proceduru u kojoj su spomenuti SQL postupci združeni :

U kodu koristimo slijedeće oznake (varijable), koje je potrebno pri instalaciji promijeniti s odgovarajućim imenima: #SERVER# zamijeniti s imenom servera, na kojem je baza podataka za Time&Space #SPICA# zamijeniti s imenom baze koju upotrebljava aplikacija Time&Space

Najprije izbrišemo eventualne postojeće triggere

drop trigger dbo.dl_HR_UraHrPoklic2TSUsers
drop trigger dbo.dl_HR_UraOdDel2TSUsers_Delete
drop trigger dbo.dl_HR_UraOdDel2TSUsers_Insert
drop trigger dbo.dl_HR_UraOdDel2TSUsers_Update
drop trigger dbo.dl_HR_UraParam2TSUsers

Prvi trigger po promjeni naziva javlja u Pantheonu promjenu naziva i u Time&Space.

create trigger [dbo].[dl_HR_UraHrPoklic2TSUsers] on HRPOKLIC
with encryption
for update as

set nocount on

set xact_abort on

if Update(NAZIV)
  begin
    update #STREZNIK#.[#tsspica#].[dbo].USERS
       set Occupation = (select Naziv from hrPoklic where Poklic = (select Poklic from inserted))
       where ID in (select MATICNASTEV collate SQL_Slovenian_CP1250_CI_AS from ODDEL where POKLIC = (select POKLIC from deleted))
    end

set xact_abort off

Drugi trigger kod brisanja djelatnika u Pantheonu izbriše djelatnika i u Time&Space.

create trigger [dbo].[dl_HR_UraOdDel2TSUsers_Delete] on ODDEL
with encryption
for delete as

set nocount on

set xact_abort on

delete #STREZNIK#.[#tsspica#].[dbo].USERS
  from #STREZNIK#.[#tsspica#].[dbo].USERS, Deleted
  where Id = Deleted.MaticnaStev collate SQL_Slovenian_CP1250_CI_AS 

set xact_abort off

 Treći trigger kod unosa novog djelatnika u Pantheonu unese djelatnika i u Time&Space.

create trigger [dbo].[dl_HR_UraOdDel2TSUsers_Insert] on ODDEL
with encryption
for insert as

set nocount on

set xact_abort on

-- Host: 1 - Zaposlen 2 - Obiskovalec

insert into #STREZNIK#.[#tsspica#].[dbo].USERS (HOST, ID) 
  select 1, (select MATICNASTEV collate SQL_Slovenian_CP1250_CI_AS from inserted) 

set xact_abort off

Četvrti trigger kod promjene podataka o djelatniku (prezime, ime, adresa, telefon, datum rođenja, odjel, e-mail) u Pantheonu promijeni te vrijednosti i u Time&Space.

create trigger [dbo].[dl_HR_UraOdDel2TSUsers_Update] on ODDEL
with encryption
for update as

set xact_abort on

set nocount on

if Update(PRIIMEK) or Update(IME) or Update(ULICA) or Update(KRAJ) or Update(DRZAVA)
or Update(TELEFON) or Update(DATUMROJSTVA) or Update(ODJEL) or Update(EMAIL)
 begin
   update #STREZNIK#.[#tsspica#].[dbo].USERS
   set LASTNAME = RTrim(PRIIMEK),
       FIRSTNAME = RTrim(IME),
       ADDRESS = ULICA,
       CITY = KRAJ,
       STATE = DRZAVA,
       PHONE = TELEFON,
       BIRTH = DATUMROJSTVA,
       DEPARTMENT = ODJEL,
       EMAIL = Inserted.EMAIL
   from Inserted
   where ID = Inserted.MATICNASTEV collate SQL_Slovenian_CP1250_CI_AS
 end

if Update(SLIKA)
 begin
   update #STREZNIK#.[#tsspica#].[dbo].USERS
     set PICTURE = ODDEL.SLIKA
     from #STREZNIK#.[#tsspica#].[dbo].USERS, ODDEL, inserted, deleted
     where ODDEL.MATICNASTEV = inserted.MATICNASTEV 
       and ID = deleted.MATICNASTEV collate SQL_Slovenian_CP1250_CI_AS
       and ODDEL.DELAVEC = inserted.DELAVEC
       and ODDEL.DELAVEC = deleted.DELAVEC
end

if Update(POKLIC)
 begin
   update #STREZNIK#.[#tsspica#].[dbo].USERS
     set OCCUPATION = HRPOKLIC.NAZIV
     from HRPOKLIC, Inserted, Deleted
     where HRPOKLIC.POKLIC = Inserted.POKLIC
       and ID = Deleted.MATICNASTEV collate SQL_Slovenian_CP1250_CI_AS
       and Inserted.DELAVEC= Deleted.DELAVEC
 end

if Update(MATICNASTEV)
 begin
   update #STREZNIK#.[#tsspica#].[dbo].USERS
     set ID = Inserted.MATICNASTEV
     from Inserted, Deleted
     where ID = Deleted.MATICNASTEV collate SQL_Slovenian_CP1250_CI_AS
       and Inserted.DELAVEC= Deleted.DELAVEC
 end

set xact_abort off

Peti trigger kod promjene naziva našeg poduzeća u Pantheonu promijeni naziv i u Time&Space.

create trigger [dbo].[dl_HR_UraParam2TSUsers] on PARAM
with encryption
for update as

set nocount on

set xact_abort on

if Update(NASEPODUZEĆE)
  begin
    update #STREZNIK#.[#tsspica#].[dbo].USERS
      set COMPANY = (select NASEPODUZEĆE from Inserted)
      where COMPANY = (select NASEPODUZEĆE from Deleted) collate SQL_Slovenian_CP1250_CI_AS
  end

set xact_abort off

Prvi SQL, koji je dokumentiran/neaktivan (aktiviramo ga tako što odstranimo prva dva znaka --) izbriše postojeće djelatnike u Time& Space. UPOZORENJE!!! U slučaju da pokrenete taj redak, izbrisati će Vam se svi djelatnici i te podatke više neće biti moguće obnoviti.

--delete from #STREZNIK#.[#tsspica#].[dbo].USERS

Drugi SQL unese korisnike iz Pantheona u Time&Space. UPOZORENJE!!! Kod svakog pokretanja ovog retka se prenesu svi djelatnici iz Pantheona u Time&Space, dakle, kod višestrukog pokretanja će biti djelatnici više puta uneseni.

insert into #STREZNIK#.[#tsspica#].[dbo].USERS (Lastname, Firstname, Address, City, State, Phone, Fax, ID, Birth,
         Occupation, Bdgno, Company, Department, Subdepartment, Host, Picture, EMail, Pin, BdgChangedOn, Other)
select RTrim(cast(Priimek as VarChar(40))) as LastName,
       RTrim(cast(Ime as VarChar(25)) as FirstName,
       cast(Ulica as VarChar(50)) as Address,
       cast(Kraj as VarChar(50)) as City,
       cast(Drzava as VarChar(50)) as State,
       cast(Telefon as VarChar(15)) as Phone,
       cast('' as VarChar(15)) as Fax,
       cast(MaticnaStev as VarChar(13)) as Id,
       DatumRojstva as Birth,
       cast((select Naziv from hrPoklic where Poklic = D.Poklic) as VarChar(50)) as Occupation,
       null,
       cast((select NasePoduzeće from Param) as VarChar(50)) as Company,
       cast(Odjel as VarChar(50)) as Department,
       cast('' as VarChar(50)) as SubDepartment,
       cast(1 as SmallInt) as Host,
       Slika,
       cast(EMail as VarChar(30)) as EMail,
       cast('' as VarChar(6)) as Pin,
       null, null
from OdDel D

Nakon izvedenih procedura, slijedi prvo pokretanje aplikacije Time &Space pri kojem je potrebno unijeti prije kreirano korisničko ime (login): TSSPICA i pripadajuću lozinku;