Produced by Araxis Merge on 5/2/2019 1:17:39 PM Central 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 | C:\AraxisMergeCompare\Pri_un\EPRS\EPRS_ODSDB\EPRS.ODSDB\EPRS.ODSDB | ReadMe.txt | Thu Apr 18 16:51:44 2019 UTC |
2 | C:\AraxisMergeCompare\Pri_re\EPRS\EPRS_ODSDB\EPRS.ODSDB\EPRS.ODSDB | ReadMe.txt | Tue Apr 30 12:50:28 2019 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 2 | 64 |
Changed | 1 | 2 |
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 | Before ope ning the s olution, r ename the solution t o somethin g more des irable wit h these st eps. To p rovide a m ental anch or, let's call the n ew project MyDbProje ct. | |
2 | ||
3 | 1. Rename Staging-D b.sln to M yDbProject .sln | |
4 | 2. Right- click on t he MyDbPro ject.sln f ile and op en in an e ditor (e.g ., Notepad ) | |
5 | 3. Replac e any refe rence to S taging-Db with MyDbP roject | |
6 | 4. Save t he file | |
7 | 5. Rename the Stagi ng-Db fold er to MyDb Project | |
8 | 6. Drill down to th e MyDbProj ect folder | |
9 | 7. Rename the Stagi ng-Db.dbmd l file to MyDbProjec t.dbml | |
10 | 8. Rename the Stagi ng-Db.sqlp roj file t o MyDbProj ect.sqlpro j | |
11 | 9. Right- click on t he MyDbPro ject.sqlpr oj file an d open in an editor (e.g., Not epad) | |
12 | 10. Replac e any refe rence to S taging_Db and Stagin g-Db with MyDbProjec t | |
13 | 11. Save t he file | |
14 | 12. Rename the Stagi ng-Db.sqlp roj.user f ile to MyD bProject.s qlproj.use r | |
15 | 13. The pr oject is n ow safe to launch by double-cl icking on the MyProj ect.sln fi le in the root folde r. | |
16 | If there are any error s in openi ng, then s omething i n one of t he files m issed the renaming. | |
17 | An y other tr oubles, pl ease conta ct Ken PII ) | |
18 | ||
19 | The folder structure of the pr oject is d esigned to be simila r to that of SQL Ser ver. | |
20 | Plus the f olders are the ones typically needed tho ugh not al l-inclusiv e. | |
21 | In additio n, there a re some fi les of int erest to b e aware of : | |
22 | * Storage- -Filegroup s and File s--contain s the typi cal filegr oup/file s tructure t hat would be needed. | |
23 | So me additio nal filegr oups/files may be ne eded, depe nding on t he nature of the dat a to be st ored | |
24 | * Programm ability--S tored Proc edures--co ntains to reporting stored pro cedures (u spRptWebLo gDetails a nd uspRptG etDataDict ionary) | |
25 | * Programm ability--F unctions-- contains t wo table-b ased user defined fu nctions (u fnGetError Info and u fnSplit) | |
26 | * Security --Schemas- -contains a zraw sch ema that i s useful i f there is a need to regularly bring in raw data f rom anothe r source | |
27 | an d want to segregate those tabl e objects from the o nes locate d in dbo | |
28 | * Security --Roles--c ontains a db_execute role. Cr eating thi s role and assigning Execute p rivileges to it make s it easie r | |
29 | to grant rea d/write/ex ecute priv ileges to database b ack-end us ers and to web accou nts, witho ut an inor dinate amo unt of | |
30 | da tabase obj ect manage ment (the alternativ e is ugly and time-c onsuming!) | |
31 | * Tables-- WebLogs is a sample table cons truct to m ake help f acility ta ble/constr aints/inde xes/data d ictionary object cre ation; | |
32 | in cludes com ment marks for where to place things | |
33 | TE ST- |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.