Produced by Araxis Merge on 9/9/2019 5:42:10 PM Eastern Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
# | Location | File | Last Modified |
---|---|---|---|
1 | Webvram-v4.zip\20190725-webvram-source.zip\Sources\WebVRAM.DB\Scripts | Script.PostDeployment.sql | Tue Jul 23 23:11:38 2019 UTC |
2 | Webvram-v4.zip\20190725-webvram-source.zip\Sources\WebVRAM.DB\Scripts | Script.PostDeployment.sql | Fri Sep 6 20:17:07 2019 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 3 | 124 |
Changed | 2 | 12 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
Whitespace | |
---|---|
Character case | Differences in character case are significant |
Line endings | Differences in line endings (CR and LF characters) are ignored |
CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
1 | /* | |
2 | Post-Deplo yment Scri pt Templat e | |
3 | ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------ | |
4 | This file contains SQL statem ents that will be ap pended to the build script. | |
5 | Use SQLCM D syntax t o include a file in the post-d eployment script. | |
6 | Example: :r .\ myfile.sql | |
7 | Use SQLCM D syntax t o referenc e a variab le in the post-deplo yment scri pt. | |
8 | Example: :setv ar TableNa me MyTable | |
9 | SELEC T * FROM [ $(TableNam e)] | |
10 | ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------ | |
11 | */ | |
12 | ||
13 | -- Referen ce Data fo r VistaSit es | |
14 | MERGE INTO VistaSite s AS Targe t | |
15 | USING (VAL UES | |
16 | (32000, 25 5, 'Azure 820A', '82 0A', ' URL: PORT ), | |
17 | (32001, 25 4, 'Azure 820B', '82 0B', ' URL: PORT ) | |
18 | ) | |
19 | AS Source (VistaSite ID, VisnNu mber, Site Name, Site Number, Rp cHostname, RpcPort) | |
20 | ON Target. VistaSiteI D = Source .VistaSite ID | |
21 | -- update matched ro ws | |
22 | WHEN MATCH ED THEN | |
23 | UPDATE SET | |
24 | Ta rget.VisnN umber = So urce.VisnN umber, | |
25 | Ta rget.SiteN ame = Sour ce.SiteNam e, | |
26 | Ta rget.SiteN umber = So urce.SiteN umber, | |
27 | Ta rget.RpcHo stname = S ource.RpcH ostname, | |
28 | Ta rget.RpcPo rt = Sourc e.RpcPort | |
29 | -- insert new rows | |
30 | WHEN NOT M ATCHED BY TARGET THE N | |
31 | INSERT (VistaSit eID, VisnN umber, Sit eName, Sit eNumber, R pcHostname , RpcPort) | |
32 | VA LUES (Vist aSiteID, V isnNumber, SiteName, SiteNumbe r, RpcHost name, RpcP ort) | |
33 | -- delete rows that are in the target bu t not the source | |
34 | WHEN NOT M ATCHED BY SOURCE THE N | |
35 | DELETE ; | |
36 | GO | |
37 | ||
38 | /* | |
39 | Setup defa ult user p rofiles | |
40 | */ | |
41 | ||
42 | SET IDENTI TY_INSERT dbo.Users ON | |
43 | ||
44 | -- Referen ce Data fo r Users | |
45 | MERGE INTO dbo.Users AS Target | |
46 | USING (VAL UES | |
47 | (1, ' D N S ', 32000), | |
48 | (2, ' D N S ', 32000), | |
49 | (3, ' D NS ', 32000), | |
50 | (4, ' D NS ', 32000) | |
51 | ) | |
52 | AS Source (UserID, A DUsername, HomeVista SiteID) | |
53 | ON Target. UserID = S ource.User ID | |
54 | -- update matched ro ws | |
55 | WHEN MATCH ED THEN | |
56 | UPDATE SET | |
57 | Ta rget.ADUse rname = So urce.ADUse rname, | |
58 | Ta rget.HomeV istaSiteID = Source. HomeVistaS iteID | |
59 | -- insert new rows | |
60 | WHEN NOT M ATCHED BY TARGET THE N | |
61 | INSERT (UserID, ADUsername , HomeVist aSiteID) | |
62 | VA LUES (User ID, ADUser name, Home VistaSiteI D) | |
63 | -- delete rows that are in the target bu t not the source | |
64 | WHEN NOT M ATCHED BY SOURCE THE N | |
65 | DELETE ; | |
66 | GO | |
67 | ||
68 | SET IDENTI TY_INSERT dbo.Users OFF |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.