Lialis - Serfed Assicurazioni Srl
Contents
1. 26 22 27 mo Cu M 28 4 Add the user to the database and select the appropriate FOlOS ccccececcecccnecseneeeeeeneeanaaeeeeeeeeeeeeeeeeeeeeeeeeaceeeeeeecaaaeasaaeeeeesaaaaaaaaesseesaaaaaaaaessesaaaaaeneeessesaaaaneseeesssansssetsees 29 56 Ofeale an ODBC Connection to log 1010106 SOL SOIL A 30 Convert Notes Data to SQL User Manual v1 3 Introduction The Lialis Convert Notes Data to SQL application is a tool for mapping and exporting Notes Form and Field data via Excel to SQL This is useful when Notes data including Rich Text and attachments needs to be transferred to an SQL database Key notes An affordable tool for a complex process The tool can connect with any other database system with ODBC and OLEDB support The tool establishes a connection between your Lotus Domino environment and a different database system for short term data migrations for example to phase out the Lotus Domino environment The tool contains an update mechanism after transportation the update mechanism checks the Lotus Notes databases for updates and transports these updates to a different location in SQL same table For SQL2. fal Files Cancel al Then click the Execute action in the toolbar This will create the table for the selected sql file zii Microsoft SQL Server Management Studio File Edit Query Project Tools Window Community Help uere Uy a oS 198 4 converse 281 Object Explorer EL A B0147 conver 1_Otables sql 5WBO147 maste chttables a x Connect SY 7 EXISTS SELECT 1 FROM sys objects WHERE OBJECT ID OBJ pam 5WB0147 I Server 9 0 4035 ARBONED Isd adapt RU WEE Databases GO i Seah CREATE TABLE T_RDARCHIEF_ABV_1 Server Objects Replication UNIQUEID NVARCHAR 64 Management ABV_RUNNO NVARCHA R 30 Notification Services TEAMNR NVARCHAR SQL Server Agent ABV DOSS VERS ALF NVARCHAR max ABV 0088 OR NVARCHAR ABV 0088 PRS ATL WKN NVARCHAR 30 ABV BRANCHE CODE 4 NVARCHAR ABV DOSS VERS NAAM AFD NVARCHAR max ABV DOSS VERS NAAM 4 NVARCHAR max MNIADCHAD es 4 b 3 5 completed successfully When all sql files are imported and executed click the Refresh button to see the newly created tables E Microsoft SOL Server Management Studio File Hew Query Li Edit View Project Tools Object Explorer on Ei El nect
3. a SWBO14 SOL Servers 0 4035 ARB Databases System Databases Database Snapshots T conversie Tables Views Synonyms Pragrammabiliby Service Broker Storage Security Ca Security Server Objects Replication Management Notification Services b SQL Server Agent E E Ed EH Ed E Rd Bd Database Diagrams Community Help D Object Explorer Details Tables SWBO14 7 Databases conversie Tables Mame Schema created System Tables C T BERZIEK REGBZ 1 dbo c T_RDARCHIEF_ABY_1 dbo E T_ROARCHIEF_ABYI_ 1 dbo Cd T_RDARCHIEF_ADHRAP_1 dba cT RDARCHIEF ADHSELRAP 1 dbo E T_ROARCHIEF_ADHYOLRAP_1 dbo c T RDARCHIEF ADHVOLRAP 1 dbo c T_RDARCHIEF_ADHYOLSELRAP_1 dbo Cd T RDARCHIEF AFSPRAKEM 1 dbo c T_RDARCHIEF_CUMRAP_1 dbo c T_RDARCHIEF_CUMUITRAP_1 dbo cd T_ROARCHIEF_CUMUITRAP_2 dbo E T RDARCHIEF EFFECTEVALLIATIE 1 dbo c T RDARCHIEF 1 dbo E T_RDARCHIEF_MEDRAP_1 dbo c T RDARCHIEF MEDRAP 1 dbo C T RDARCHIEF PBS 1 dbo c T RDARCHIEF PBS AV 1 dbo RDARCHIEF 51 1 dbo Cd T RDARCHIEF PRESTATIE 1 dbo C T RDARCHIEF RSI AFSPRAKEN 1 dbo c T RDARCHIEF R5I INVEMTARISATIE 1 dbo Se pene oe a 527 2010 527 2010 527 2010 527 2010 527 2010 527 2010 527 2010 5 27 2010 5 27 2010 5272010 512712010 527 2010 527 2010 527 2010 527 2010 527 2010 527 2010 527 2010 512712010 5272010 5 27 2010 5 27 2010 elia
4. Felis me n 11 3 Noles MESE Error Bookmark not defined ow MEC ene MEER ee eee en eee eee 12 220 M RU mm 14 Viro Mart E eee ee Ne 15 OO Ro 17 lo CNS clc MR 18 Step 4 Create Random Test files EA Haas sas s ases e saa asas nhau nu 19 gil M ee eee QE 19 Import tnie sdi files inito hie SQL ata ase a poda aumente hec tineis un 20 Sx E m 29 Append 26 THES OE SCV Maradonan
5. gt form Convert Notes data to SQL application e added authorization script 19 01 2011 Convert Notes Data to SQL v1 3 e Complete rewrite of Data Integrity Logging Data Integrity logs are now smaller e Added demonstration mode to the authorization Authorization server still needs to be contacted Added OLEDB Rewrite of CheckDeletions runs much faster now Data Integrity checker works correctly now Only OLEDB supported Removed table prefixes for fieldnames Convert Notes Data to SQL User Manual v1 3 Contents OS WON e ese we E 2 PUES ONY qe 3 MSO TRE MEE Te a 4 1 o RESET ss M 5 E TER 5 006666 5 2 OTS SO Ne Me E 7 2A PTO GOC ONM a MM UT 8 22 C C C EA 10 2 3
6. 2004 2 13 Interventie Utrecht MO ESZ MD Archief 2 6 Archief OUD overvecht Notes Dump to Excel v1 01 Notes 501 v1 0 RD Archief 1 0 Filename applications 47AN 5 252 berziek nsf Each document contains information of all fields on the specified form Convert Notes Data to SQL User Manual v1 3 Convert Notes Data to SQL User Manual v1 3 Form Mapping for form REGBZ Source Field Destination Table Pestination Field Datatype Elements 0 4 CONFLICT EXT 1 1 OTEREFS 1 1 EREVISIONS DATETIMES 4417 18 EUPDATEDBY AMES 4417 4 Az 2386 1 hz AANDOENING SPOOR EXT 2031 1 Az AANDOENINGEN EXT 2031 1 57 AARD BEROEPSZIEKT EXT 2386 1 2386 1 Az ACTIVITEIT EXT 4417 1 Az ADVIES WG EXT 4417 z Az ADVIEZEN EXT 4417 1 87 _ ARBODIENST EXT 4417 1 5 BEDRIJFSARTS EXT 2031 1 57 BEROEP EXT 2031 1 Az BEROEP CODE EXT 4417 1 87 BEROEPSZIEKTE EXT 2031 1 RT CAG 1 Convert Notes Data to SQL User Manual v1 3 ep 2 Generate SQL In this step an SQL script is generated for creating tables The sql files are saved in the C Temp directory The limit to a table row is 512 columns because of a limitation in Microsoft SQL Server when there are more columns fields involved the table is split up Note that all field types are converted to nvarchar max except date time values which are converted in nvarchar 12 and a
7. CREATOR to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP CREATOR TEXT DATABASE to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP DATABASE TEXT DOCCATEGORY to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP DOCCATEGORY TEXT DOCICON to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP DOCICON NUMBERS DOCTITLE to INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP DOCTITLE TEXT ERAP DATUM to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP ERAP DATUM DATETIMES ERAP MEDEWERKER to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP ERAP MEDEWERKER TEXT ERAP MEMO to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP ERAP MEMO TEXT FORM to INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP FORM TEXT JN to T INTERVENTIE RAPPORTEN JN TEXT NEWDOC to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP NEWDOC TEXT UNID to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP UNID TEXT VEST SERVERNAAM to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP SERVERNAAM TEXT WN AANSTELLING ID to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP AANSTELLING ID TEXT WN NAAM to INTERVENTIE RAPPORTEN WN NAAM TEXT WN NAAM VL to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP WN NAAM VL TEXT WN NAAM VV to T INTERVENTIE RAPPORTEN WN NAAM VV TEXT WN NAAM WG to T INTERVENTIE RAPPORTEN WN NAAM WG TEXT WN SOFINUMMER to INTERV
8. SBRAII 1020 POLICYREGISTRATION LCLADMIN TEXT 6 3 1 5 5 Administrators NL ATS Systeembeheer 1021 POLICYREGISTRATION COMMENTS RICHTEXT 6 0 1 1022 POLICYREGISTRATION OWNER AUTHORS 6 6 1 CN Administrator O Sennen CN Domino Administrator O lv Groep 1023 POLICYREGISTRATION LOCALADMIN AUTHORS 6 6 2 CN Administrator O Sennen CN Damino Administrator O lv Groep 1024 POLICYREGISTRATION TEXT 6 6 1 PolicyRegistration PolicyRegistration 1025 POLICYREGISTRATION DOCUMENTACCESS AUTHORS amp amp 1 PolicyModifier PolicyModifier 1026 POLICYREGISTRATION CFGDOC TEXT E 0 1 1027 POLICYREGISTRATION SPOLICYIFPITEMS TEXT 6 1 1028 POLICYREGISTRATION SPOLICYPOITEMS TEXT 1 31 RegSrvr 1029 POLICYREGISTRATION SPOLRDRS READERS 6 0 1 1030 POLICYREGISTRATION SPLCYREG NUMBERS 6 1 0 0 1031 POLICYREGISTRATION FULLNAME TEXT E E 1 Sennen Registration lv Groep Basis 1032 POLICYREGISTRATION DBOTA TEXT 2 1 450 200 1033 POLICYREGISTRATION WARNTHRESH TEXT 2 1 400 150 1034 POLICYREGISTRATION SPOLMDTM DATETIMES 1 26 8 2008 2 32 3 6 2009 12 26 1035 POLICYREGISTRATION SSIGNATURE SIGNATURE 0 1 1036 POLICYREGISTRATION SUPDATEDBY NAMES 6 E 2 CN Administratar O Sennen CN M Vnsmer OU Iv Software O Iv G 1037 POLICYREGISTRATION SREVISIONS DATETIMES amp 8 25 1 2008 17 28 23 6 2005 9 32 1038 POLICYREGISTRATION SEXTERNALFIELDS TEXT 1 1 1 1 1039 POLICYREGISTRATION DONT SET STRING TEXT 1 1 1 Don t set value 1040 POLICYSECURITY FORM TEXT 7 7 1 PolicySecurity Poli
9. by default when the check is done Please note that this application only works when the source Domino server runs on a Windows platform Furthermore the Demonstration version will not affect the output of the Notes Field Dump process The export of Notes Field Data to SQL however will be limited to 5 forms with a maximum of 10 fields for each form in the Demonstration version To enable a full data transport to SQL please contact marten vosmer lialis com Convert Notes Data to SQL User Manual v1 3 Notes Field Dump The Notes Field Dump application contains only one view called Agent Log This view contains the log entries when an agent is started and finished and when an error occurs during the agent run The view contains 2 buttons Button Edit Profile opens the configuration document of the application Button Manual Excel Dump starts the Dump To Excel agent Notes Field Dump v1 0 Agent Log IBM Lotus Notes Edit View Create Actions Help S428 suicm of Address fil Notes Field Dump v1 0 Agent Olialis the hoamsesaurcing ET 4 Da A Edit Frafile Manual Excel Dump Date amp Time Error Message 05 05 7010 05 05 2010 14 54 42 Agent Dump To Excel started Manual 05 05 2010 14 55 26 AgentDump To Excel finished Manual fi Hotes Dump To Excel Agent Log EOR v Zz 1
10. it is clear this contains modifications to the earlier transported data The tool imports form and field names from a Microsoft Excel file that is generated with the Lialis Notes Field Dump tool after which all the fields are mapped in a table and field values are added Lialis Notes Field Dump tool is now integrated with the Notes 2 SXL tool and form the Convert Notes Data to SQL application The tool can transfer text rich text attachments Rich text conversion is currently only available for the Windows platform The transfer is secured by a data integrity log that logs a checksum for every field containing a value that has been transferred The tool performs the preliminaries the SQL supplier will perform the transportation to the final database system Working process Mugs zu o 0 Lialis implements a separate Lotus Domino transportation server containing the Convert Notes Data to SQL application The Lotus Notes applications that need to be transported are replicated to the transportation server The Replication process is disabled The Notes Field Dump tool generates a Microsoft Excel file The Convert Notes Data to SQL application is activated to import form and field names from the Excel file All fields are mapped in a table and field values are added The Convert Notes Data to SQL application transfers the content to SQL and logs every field value that has been transferred data integrity log The Replication proc
11. 10 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 16 37 9 5 2010 2 16 37 9 5 2010 2 16 37 9 5 2010 2 16 37 9 5 2010 2 16 37 9 5 2010 2 16 37 9 5 2010 2 16 37 9 5 2010 2 16 37 Mapping field Mapping field Mapping field Mapping field Mapping field Convert Notes Data to SQL User Manual v1 3 WN_NAAM_WG to T_INTERVENTIE_VERVOLGACTIE VAC_WN_NAAM_WG TEXT WN SOFINUMMER to INTERVENTIE VERVOLGACTIE VAC SOFINUMMER TEXT WN TEAM to INTERVENTIE VERVOLGACTIE VAC TEAM NUMBERS ZM DATUM GEVAL to T INTERVENTIE VERVOLGACTIE VAC ZM DATUM GEVAL TEXT ZM OORZAAK to T INTERVENTIE VERVOLGACTIE VAC ZM OORZAAK TEXT Start processing Done processing 1640 documents 0 attachments Disconnecting form VAC Connection to form ERAP Mapping field BEDRIJFSNUMMER to T INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP BEDRIJFSNUMMER TEXT Connecting to ODBC Out Table T INTERVENTIE RAPPORTEN EINDRAPPORTAGE Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field
12. 39 9 5 2010 2 09 39 9 5 2010 2 09 39 9 5 2010 2 09 39 9 5 2010 2 09 39 9 5 2010 2 09 39 9 5 2010 2 09 39 9 5 2010 2 09 39 9 5 2010 2 09 39 9 5 2010 2 09 39 9 5 2010 2 09 40 9 5 2010 2 09 40 9 5 2010 2 09 40 9 5 2010 2 09 40 9 5 2010 2 09 40 9 5 2010 2 09 40 9 5 2010 2 09 40 9 5 2010 2 09 40 9 5 2010 2 09 40 9 5 2010 2 12 59 9 5 2010 2 12 59 9 5 2010 2 12 59 9 5 2010 2 12 59 9 5 2010 2 12 59 9 5 2010 2 12 59 9 5 2010 2 12 59 9 5 2010 2 12 59 9 5 2010 2 12 59 9 5 2010 2 13 00 9 5 2010 2 13 00 9 5 2010 2 13 00 9 5 2010 2 13 00 9 5 2010 2 13 00 9 5 2010 2 13 00 9 5 2010 2 13 00 9 5 2010 2 13 00 Starting Run 1 Starting process on database CN App02 O Lialis applications 47AN S 252 berziek nsf Connecting to ODBC Blob Table T BLOB Connection to form REGBZ Mapping field BZ AANDOENING to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ AANDOENING TEXT Connecting to ODBC Out Table T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field Mapping field BZ AANDOENING _SPOOR to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ AANDOENING SPOOR TEXT BZ AANDOENINGEN to T_BERZIEK_REGISTRATIEFORMULIER_BEROEPSZ
13. AAK_CODE EXT 2031 OOP TAAK CONE ORMULIER_BEROEPSZIE EGB2_B2_GESLACHT n21 Convert Notes Data to SQL User Manual v1 3 1 1 19 os a Convert Notes Data to SQL User Manual v1 3 Step 4 Create Random Test files optional This is an optional step to check if mapping is working fine This step will create a design copy of the database in the lt original server gt lt notesdata gt temp lt original filepath gt and will fill this database with random data This step may be useful when you want to export large databases and you want to be sure that the forms and fields are mapped correctly Reset This action will reset the run number on all documents to 0 For more information about run numbers view 3 4 The pump agent This action is not recommended to use as it may disturb the process Convert Notes Data to SQL User Manual v1 3 Import the sql table files into the SQL database When the application is using the ODBC Connector an ODBC Connection needs to be made on the Operating System This is not needed for use with OLEDB More information on this topic can be found in Appendix Setup ODBC When and the SQL database and the files for tables have been created you need to import the tables into the SQL database To do this open Server M
14. ENTIE RAPPORTEN WN SOFINUMMER TEXT WN TEAM to INTERVENTIE RAPPORTEN EINDRAPPORTAGE ERAP WN TEAM NUMBERS Start processing Done processing 1160 documents 0 attachments Disconnecting form ERAP Connection to form VER Mapping field AANSLUITNUMMER to T INTERVENTIE VERRICHTING VER AANSLUITNUMMER TEXT Connecting to ODBC Out Table T INTERVENTIE VERRICHTING Mapping field AANTALVERR to T INTERVENTIE VERRICHTING VER AANTALVERR NUMBERS Convert Notes Data to SQL User Manual v1 3 Appendix Setup ODBC 1 Start SQL Server Management Studio gt Windows Catalog gf Connect to Server x A Winde ty Windows Update Microsoft Windows Server System SQL Server 2005 Documents gt ig Broadcom Fujitsu si Server type Database Engine Jitsu SIEMENS i b IF Fujitsu Siemens Serveriew Server name 0147 Search Microsoft Office Authentication Windows Authentication aH Microsoft SQL Server 2005 b i Analysis Services Help and Support Startup gt 3 Configuration Tools User name ar BONED lsd adapt T IF Trend Micro OfficeScan Client gt Documentation and Tutorials Internet Explorer i Performance Tools Log Off Isd adapt Outlook Express SQL Server Management Studio Remote Assistance Shut Down Lotus ti gt Accessories 17 Administrative Tools Programs Run H
15. FEST NVARCHAR max REGBZ_BZ_NAAM_WwG NVARCHAR max REGBZ BZ NCVB ARTSCODE NVARCHAR max REGBZ BZ NCVB VESTCODE NVARCHAR max REGBZ BZ OORZAAK NVARCHAR max REGBZ BZ OORZAAK CODE NVARCHAR max REGBZ BZ OORZAAK CODE2 NVARCHAR max REGBZ 2 OORZAAK CODE3 NVARCHAR max REGBZ BZ OORZAAK2 NVARCHAR max REGBZ_BZ_OORZAAK3 NVARCHAR max REGBZ_BZ_OPMERKINGEN NVARCHAR max REGBZ_BZ_RELATIE NVARCHAR max REGBZ_BZ_SECTOR NVARCHAR max REGBZ BZ SECTOR CODE NVARCHAR max REGBZ BZ TOESTEMMING NVARCHAR max REGBZ BZ VOLGNUMMER NVARCHAR 30 REGBZ_BZ_WERKZAAMHEDEN NVARCHAR max REGBZ 2 WIE INGELICHT NVARCHAR max REGBZ 2 ZEKERHEID NVARCHAR max REGBZ FORM NVARCHAR max REGBZ RELATIE NVARCHAR max REGBZ STATUSVERZENDEN NVARCHAR max REGBZ WN AANSTELLING ID NVARCHAR GO ep 3 Map Fields From SQL This step will map all Notes fields to the corresponding destination tables The columns Destination Table T_ form name en Destination Field f_ field name are set the Form document of the configured database A character the destination table or field column means that this field is excluded from mapping When using this action you have to select the database from the Configured databases view with the corresponding SQL file SOL Create table file to import Zoeken in Temp 4 createBeroepsziekten_2 tabl
16. IEKTEN REGBZ_BZ_AANDOENINGEN TEXT BZ AARD_BEROEPSZIEKTE to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ AARD BEROEPSZIEKTE TEXT BZ ACTIVITEIT to T_BERZIEK_ REGISTRATIEFORMULIER_ BEROEPSZIEKTEN REGBZ BZ ACTIVITEIT TEXT BZ ADVIES WG to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ ADVIES WG TEXT BZ ADVIEZEN to T BERZIEK REGISTRATIEFORMULIER _ BEROEPSZIEKTEN REGBZ BZ ADVIEZEN TEXT BZ ARBODIENST to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ ARBODIENST TEXT BZ BEDRIJFSARTS to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ BEDRIJFSARTS TEXT BZ BEROEP to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ BEROEP TEXT BZ BEROEP CODE to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ BEROEP CODE TEXT BZ VOLGNUMMER to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ VOLGNUMMER NUMBERS BZ WERKZAAMHEDEN to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ WERKZAAMHEDEN TEXT BZ WIE INGELICHT to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ WIE INGELICHT TEXT BZ ZEKERHEID to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ BZ ZEKERHEID TEXT FORM to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ FORM TEXT RELATIE to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ RELATIE TEXT STATUSVERZENDEN to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ STATUSVERZENDEN TEXT WN AANSTELLING ID to T BERZIEK REGISTRATIEFORMULIER BEROEPSZIEKTEN REGBZ WN AANSTE
17. LLING ID TEXT Start processing Done processing 1417 documents 0 attachments Disconnecting form HEGBZ Starting process on database CN App02 O Lialis applications 47AN S 252 interventie nsf Connecting to ODBC Blob Table T BLOB Connection to form VAC Mapping field AC DATUM to T INTERVENTIE VERVOLGACTIE VAC AC DATUM DATETIMES Connecting to ODBC Out Table T INTERVENTIE VERVOLGACTIE Mapping field AC DATUM VERVOLG to T INTERVENTIE VERVOLGACTIE VAC AC DATUM VERVOLG DATETIMES Mapping field AC MEDEWERKER to T INTERVENTIE VERVOLGACTIE VAC AC MEDEWERKER TEXT Mapping field AC MEMO to T INTERVENTIE VERVOLGACTIE VAC AC MEMO TEXT Mapping field PRIORITEIT to T INTERVENTIE VERVOLGACTIE VAC AC PRIORITEIT TEXT Mapping field AC VERVOLG to T INTERVENTIE VERVOLGACTIE VAC AC VERVOLG TEXT Mapping field AC VOORBESTEMD to T INTERVENTIE VERVOLGACTIE VAC AC VOORBESTEMD TEXT Mapping field WN NAAM VL to T INTERVENTIE VERVOLGACTIE VAC WN NAAM VL TEXT Mapping field WN NAAM VV to T INTERVENTIE VERVOLGACTIE VAC WN NAAM VV TEXT 9 5 2010 2 13 00 9 5 2010 2 13 00 9 5 2010 2 13 00 9 5 2010 2 13 00 9 5 2010 2 13 00 9 5 2010 2 13 00 9 5 2010 2 15 33 9 5 2010 2 15 33 9 5 2010 2 15 33 9 5 2010 2 15 33 9 5 2010 2 15 33 9 5 2010 2 15 33 9 5 2010 2 15 33 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 2010 2 15 34 9 5 20
18. Lialis Convert Notes Data to SQL User Manual Version 1 3 Date 2011 01 19 Convert Notes Data to SQL User Manual v1 3 Foreword Lotus Domino environments contain a lot of content data in applications and or mail files which needs to be migrated when the organization decides to exchange the Lotus Domino environment for a different database system With the Lialis Convert Notes Data to SQL application the transfer from Lotus Domino Notes data to another database system can be arranged easily View this document to gain information about the functionalities and configuration options for the Lialis Convert Notes Data to SQL application Feel free to contact us for more questions or more information about this application and the license structure marten vosmer lialis com Convert Notes Data to SQL User Manual v1 3 History 12 05 2010 Notes to SQL v1 01 11 06 2010 Notes to SQL v1 02 e improved performance as a result of adjusted logging process database postfix in sql table name can be configured in configuration document encrypted and signed documents which are not processed are logged with the UNID issue resolved regarding fields identified as rich text and containing only text added ODBC timeout agent runtime adjusted from 1 to 4 hours 21 06 2010 Notes to SQL v1 05 e improved performance e various issues resolved 05 09 2010 Notes to SQL v1 1 2 e integrated Notes Field Dump v1 0
19. Profile document ef Save amp Close Configuration settings Notes Field Dump DB filepath s to process relative to data directory Excel output folder Convert Notes Data to SQL User Manual v1 3 Profile Document Clg this should be an existing folder jfexcel is not installed on the machine running the agent data will be dumped in a txt file oniy Include Forms that are notin use including unused forms does nof fake info account the use of computed subforms Iv Include Content columns in Excel sheet create Oy columns with content reserve T 0 5 characters per content column P Characters not regarded as content Jj Comments my gt Notes To SQL DB filepath s to process e Enter the file path s of the database s you want to dump to Excel Note that the path should be relative to the Notes Domino data directory e Databases should be separated with or a new line Excel Output folder This is the file system output folder where the Excel file is written The default value is c V Include Forms that are not in use e This option will also generate output for Forms that are not used by any document Note that computed subforms used in this form may not be available in the output Include Content columns in Excel sheet e When this box is selected default the agent will also dump some field content in the Excel sheet o Specify how many Excel columns need to be reserved for displ
20. Q oTIbH bkd UP Programmability A E5733412EF5 1 IpPdM 5Cs Rp IHBT Mp amp 78yH E3esTGPj3kavBS5 XUvDIIEN3b w Service Broker OSBBBRIDOS9FC 1 R fpk9Eei 6 G o3 GRH H lbi ht Dbse 9wJZ M z d Da75BpT6Cskc Lj Storage iin Te EER za diti tie TREE BH Security 659049 661 80 1 WuHwBoUs d be pDwkm4ngJz6Q JV Wmllavt vRH Security 72 5 2 51 1 1_ 716 deyohxHBTynwu lt 25 7 OAAqyR xrDNMT LIPvimIMFK Seren AT726BAACCSF ADO ds o xMz oELaKcne QOEu amp YXoPoohpV eSauB9KWF L olzId enBYssh Replication Management DBL BESESBS6B LkkfxrR amp m Rs TLLGSjliMCEemLl BEWOFzSCaGyBSao JMMJEDL PTSk 5d6 mfkec wE Notification Services A3A4FOFFE397 kdWj4pp Vees PIV SLmOLZ wiOQ1lMz 79 9 B8BalvnegSUf49L FM Em gj F amp xc 27 TW CTA Tbe Dalia nin polo te sade Di Keres a sem Convert Notes Data to SQL User Manual v1 3 e Status Log view shows the activity status of the pump agent Below you will find an excerpt of such a log Starttime 09 05 2010 02 08 Endtime 09 05 2010 02 16 Log 9 5 2010 2 09 32 9 5 2010 2 09 32 9 5 2010 2 09 36 9 5 2010 2 09 39 9 5 2010 2 09 39 9 5 2010 2 09 39 9 5 2010 2 09
21. Snapshots SWBO147lDatabaseslconversie Object Ex plor er a x Object Explorer Details El 1 conversie n a Database Diagrams S LI a um s 12 Y EJ Tables E 1 SWBO147 SQL Server 9 0 4035 Views fim Database Diagrams SwBO147 Synonyms CE Tables Security Programmabiity views Server Ob ARBONED sd adapt Service Broker Ga synonyms Replicatio Attach 33 View connection properties eee Programmability Manageme Restore Database Lc arig CE Service Broker Notificatio Restore Files and Filegroups Server Objects Li Storage db SQL Serve GB Replication Security Management Reports Notification Services 35 SQL Server Agent Refresh Add a user login to the SQL Server Login New Select a page LAA General Server Roles _ User Mapping A Securables Status Microsoft SOL Server Management Studio File Edit view Tools Window Community Help i Mew Query um av ug d 2 of Object Explorer Connect E m T A 5480147 SOL Server 2 0 40135 Databases Object Explorer Details c gm Connection Server SwB 147 1 Connection ARBONED Isd adapt Security Reports View connection properties bo Credential Progress Refresh Logins Server Roles Credentials Conv
22. System DSN is needed so the Domino Server Running as a service under the local system account is able to access it In the Create New Data Source window select either the SQL Native Client or the SQL Server database driver Except for some ignorable details they are the same Click Finish IODBC Data Source Administrator 21 UserDSN System DSN File DSN Drivers Tracing Connection Pooling About 1 Create New Data Source Select a driver for which you want to set up a data source Microsoft ODBC for Oracle Microsoft Paradox Driver db Microsoft Paradox Treiber db Microsoft Text Driver tst csv Microsoft Text Treiber Microsoft Visual FoxPro Driver Microsoft Visual FoxPro T reiber SQL Native Client 7 een Convert Notes Data to SQL User Manual v1 3 Select a name for the Data Source This is the name that needs to be configured in the application see 3 1 Configuration and select or add the Server that needs to be connected to This can be an IP number and can be followed by a server instance Click Next Create a New Data Source to SQL Server This wizard will help you create ODBC data source that you can use to connect to SQL Server What name do you want to use to refer to the data source Name ExampleConnectior How do you want to describe the data source Description Example Which SQL Server do you want to connect to Serve
23. anagement Studio as described in the Appendix Then choose File Open File Microsoft SOL Server Management Studio File Edit view Tools Window Community Help a Connect Object Explorer E cal Eats Hg s Disconnect Object Explorer 2 Object Explore Open m Project Solution CLrl Shift O Close 23 Elle ml Close Solution Fay File with Mew Connection Save Selected Items Ctrl 5 tat File Disconnected Save Selected Items As save al CtrH Shift 5 Lil Databases cc e essel CE Security H Page Setup Server Obje g print Ctrl P B Replication Management Recent Files 4 Notification Exit HSQL Server Convert Notes Data to SQL User Manual v1 3 Here you can select the SQL table you want to import You have to import the files one by one Click the Open button hpenn APR Look in E Temp X GE 20100525 Figas tables nobesatkach Tools ieroepsziekten_ _1tables sql Er createBLOBEables sql My Projects creakeInterventie 2004 2 19tables sql Er creabeInterventie Utrecht _O Vbables sql createMD 6 Stables sql createMD _Orchief_ 6tables sql Computer createMD_Archiel OUD _overvechthables sql createRD Archief 1 Er createRelatie Dossier 3 Obables sql File name Open Files of
24. aying field content If you for instance enter 4 the agent will generate field content for the first 4 documents of each used form o If set to O default no content is dumped to Excel o Specify how many characters of the content you want to display f set to O default no content is dumped to Excel Characters not regarded as content e you can specify which characters or strings should not be regarded as content Note that for performance reasons exact matching is used here i e fields that only contain one of the specified strings Convert Notes Data to SQL User Manual v1 3 nothing more and nothing less The default value list contains the following characters strings including space amp _ lt gt Comments Free text When a profile document doesn t yet exist and the scheduled agent is run the agent will immediately finish without checking anything In case of the manual agent a pop up dialog box will open telling you to first configure the tool After saving this form you need to start the Dump To Excel agent again Please configure the Notes Field Dump section before running the dump process Configuration settings Profile Document DB filepath s to process relative to data directory Excel output folder this should be an existing folder jfexcel is not installed on the machine running the agent data will be dumped in a txt file only Include F
25. cySecurity 1041 POLICYSECURITY STRMSG TEXT 7 0 1 1042 POLICYSECURITY VWCNT TEXT 7 0 1 1043 POLICYSECURITY HBLOAD TEXT 7 7 1 0 0 1044 POLICYSECURITY PLCYDESCR TEXT 7 2 1 lv Groep Basis Security settings default security policy 1045 POLICYSECURITY USECUSTOMPOLICY TEXT 1 0 1 1046 POLICYSECURITY PWDALWHTTP TEXT 7 7 1 1 0 1047 POLICYSECURITY PWDSYNC TEXT 7 7 1 1 1 1048 POLICYSECURITY PWDWPCSHARING TEXT 1 0 0 1049 POLICYSECURITY PWDEXP TEXT 7 7 1 1 1 1050 POLICYSECURITY PWEXPW ARN TEXT 2 1 Please change your Notes password Test Custom Warning Message 1051 pow icvsrcuRity II FNFORCE TEXT 3 n 1 Convert Notes Data to SQL User Manual v1 3 Notes to SQL 3 1 Configuration The Notes 2 SQL application contains a configuration document with configuration options Notes To SQL Lise test source databases Yes Use configuration v 1 C Temporary folder T c Atemp Attachment subfolder natesattach Table pastfix utr 4 Use Connectiontype OLEDB C ODBC Log fieldmappings Yes Data integrity Version C 1 v 2 Configuration 1 Oledb server 192 168 1 10 1433 4 Datasource Demo Database conversion Username Lialis 1 a Convert Notes Data to SQL User Manual v1 3 Use test source databases o When this option is set to Yes the pump agent will transfer only randomly generated data from test database to an SQL table This testing is useful whe
26. ememberpassward Windows Server 2003 Standard Edition File Edit view Tools Window Community Help n Mew Query Li os 2 9 Object Explorer xX Object Explorer Details Connect au m T 81 m YE SWBO147 SQL Server 9 0 40 cd 1 SWBO147 SQL Server 9 0 403 Server Objects SWEO147 Replication Management Notification Services E SQL Server Agent nope Security Server Objects Replication Management Notification Services HSQL Server Agent E EH Ed E Ed EH Convert Notes Data to SQL User Manual v1 3 2 Create a new database New Database Select a page Script Help General A Opti zi Taie Database name owmesd Durer Use full text indexing E Microsoft SQL Server Management Studio File Edit view Tools Window Community Help ug NewQuery ty 22 99 a d PARKS conversie Data PRIMARY Object Explorer conversie_log Log Not Applicable 1 By 10 percent unrestricted growth Connect ag m Y amp SWBO147 SQL Server 9 0 4035 Databases System Databases Object Explorer Details 2 8 Microsoft SQL Server Management Studio File Edit View Tools Window Community Help New Query c ita Ha 5 02 9 Ok 8 conversie 2 Database
27. ert Notes Data to SQL User Manual v1 3 15 Script 1 7 Help Login name Lialis Search C Windows authentication SQL Server authentication Password 999099099090990 Confirm password 9909000009009 Specify old password m Old password Enforce password policy Enforce password expiration User must change password at next login C Mapped to certificate Certificate name Mapped to asymmetric key Key name Default database Default lanquage 4 Add the user to the database and select the appropriate roles ff Database User New Select a page LA General Securables 2 Extended Properties Microsoft SQL Server Management Studio File Edit Tools Window Community Help 2 New Query tla tla Pa Us E 8 ud ih ES BRS Object Explorer Object Explorer Details as B Users SWBO147 Databases conversie Security Users Conect 32 m f SWBO147 SQL Server 9 0 4035 ARBONEDI Isd adapt E Databases System Databases Database Snapshots E T conversie Database Diagrams Tables Server Lj Views 4 8 2003 SWwBO147 Synonyms f quest 4 8 2003 Connection Programmability Uf INFORMATION SCHEMA 10 14 2005 ARBONED Vlsd adapt Service Broker UR sys 10 14 2005 2 Storage E Security 2 View connection properties Progress Error occurred Filter Report
28. es sql createBLOBtables sql Bestandsnaam createB eroepsziekten_2_ 1 tables sql Openen Annuleren Help 09 05 2010 17 41 30 2061 bytes Form Mapping for form REGBZ Source Field Destination Table lt lt DestinatonField CONFLICT EXT 1 EREF OTEREFS 1 REVISIONS DATETIMES 4417 SUPDATEDBY AMES 4417 37 AANDOENING _BERZIEK_REGISTRATIE REGBZ 2 AANDOENING 2386 BZ_AANDOENING_SPOOR EXT 2031 BZ_AANDOENINGEN EXT 2031 BZ_AARD_BEROEPSZIEKT EXT 2386 2386 BZ_ACTIVITEIT 4417 BZ_ADVIES_WG EXT 4417 BZ_ADVIEZEN EXT 4417 Bz ARBODIENST EXT 4417 bz BEDRIFSARTS EXT 2031 BZ_BEROEP EXT 2031 BZ_BEROEP_CODE EXT 417 BZ_BEROEPSZIEKTE EXT 2031 bz CAS EXT 2031 BZ_CAS_CODE EXT 388 BZ_CASCODE EXT 4417 BZ_CONTRACTNUMMER DATETIMES 4417 BZ_DATUM DATETIMES 4417 BZ_DATUM_MELDING_NC DATETIMES 417 B EXT 2386 BZ_DATUM_SIGNALERING EXT 326 BZ_DIAGNOSE EXT 326 BZ_ERNST_ZIEKTE_CODE PZ EXT 4417 BZ_ERNST_ZIEKTE_OMSC REGBZ 2 DATUM MELDIDATETIMES 4417 RIVING EXT 4417 BZ FUNCTIE EXT 2386 BZ_GEBDATUM TEN EXT 2386 GESLACHT BERZIEK REGISTRATIEREGBZ BZ DIAGNOSE TEXT 4417 bz INGELICHT ORMULIER_BEROEPSZIE REGBZ BZ ERNST ZIEKT TEXT 2031 BZ_MANIFEST TEN _CODE EXT 2031 BZ_NAAM_WG _BERZIEK_REGISTRATIE REGBZ_BZ_ERNST_ZIEKT TEXT 2031 BZ NCVB ARTSCODE FORMULIER BEROEPSZIE E_OMSCHRIJVING EXT 2031 BZ_NCVB_VESTCODE 2031 BZ_OORZAAK _BERZIEK_REGISTRATIE REGBZ GEBDATUM 2031 BZ_OORZ
29. ess is enabled Updates in the Lotus Notes applications are replicated The Replication process is disabled The updates are transferred to SQL and logged This process is repeated until the new database system is taken in to production by the customer Check for updates Convert Notes Data to SQL User Manual v1 3 Notes Field Dump tool Production Transportation Lotus Domino server Lotus Domino server Notes 2 SQL tool SQL database n 4 New system j SQL supplier 100 data replication per application 100 data transportation per application Data integrity 7 a log X 100 data transportation per application As per release 1 1 2 Notes Field Dump and Notes 2 SQL are integrated in one tool Convert Notes Data to SQL application The agents performing the field dump and the transfer to SQL will both check if they are authorized by Lialis to run This check is done when the agent is started and may take about 30 seconds The agent will lookup a document in the Lialis Convert Notes Data to SQL authorization database to find the server names that are authorized to run this tool To do this the agent will load the Web task if it hasn t already been loaded on the source server to return the results and will quit this task if it hasn t been loaded
30. l v1 3 2 Manual actions Note that you can only proceed with these actions when an Excel file with database forms and fields has been generated with the Notes Field Dump tool When the Convert Notes Data to SQL application is configured some manual actions must be performed to give input to the pump agent In the Configured databases view you will find the Actions button Import Excel File Generate SOL Map Fields From SQL Create Random Testfiles Reset Step 1 Import Excel File In this step the database forms and fields are imported from an Excel spreadsheet that has been generated with the Notes Field Dump tool This action will extract all form and corresponding field names from this spreadsheet into the Convert Notes Data to SQL database You need to select an Excel file to import the corresponding Notes database that you want to export to SQL Excel file to import Zoeken in _merged et E3 Ed JINVENTORY ALLDATABASES XLS 4 INVENTORY LITRECHT BERZIEK XLS E JINVEMTORY UTRECHT INTERVENTIE XLS E JINVENTORY MEDIDOS XLS Bg INVENTORY RELDOS XLS Bestandsnaam INVENTORY UTRECHT BERZIEK XLS 22 04 2010 02 23 48 37K bytes Notes to SQL Data Pump Status Log Data Log Configured databases Configuration Choose Database Server app02 Lialis Database gt 2 1 Interventie
31. n the actual production database is very large How to export randomly generate data for testing purposes is described in Step 4 Create Random Test files o When this option is set to the pump agent will transfer the data of the actual selected database to an SQL table Use configuration o Here you can select which of the 2 configurations you want the pump agent to use for transferring data Note the database mentioned in the Database field should be created manually prior to the agent run Temporary Folder o This is the folder where temporary files are saved For instance the files that are generated in Step 2 Generate SQL Attachment subfolder o This is the subfolder of the Temporary Folder where attachments are saved temporarily during the transfer process Use connectiontype o Selects whether the Pump process uses ODBC or OLEDB The DatalntegrityChecker will always use OLEDB because of an error in the ODBC driver Log Fieldmappings o If enabled the Pump agent will log all fieldmappings this can be very long so it s recommended to leave it off unless there are mapping problems Table postfix o This value will be added to the table name that is used in the SQL database You can leave this field empty if no postfix is needed Used if multiple instances of the Notes 2 SQL application are running on databases with the same filename but with different content Convert Notes Data to SQL User Manua
32. nd as appropriate while you are Use ANSI nulls paddings and warnings E Use the SQL the primam SAL Server rg nat UH he pates 1 TE LAE Change the language of SUL Server system messages to English Use strong encryption for data Perform translation for character data Use regional settings when outputting currency numbers dates and times Save long running queries to the log file E DOCUME 1 VLSD A7T3LOCALS 71 Temps15 Browse Long query time milliseconds 30000 Log ODBC driver statistics to the log file CSDOCUME 1 S LSD A TSLOCALS 1 Temps155 Browse lt Back Cancel Help ODEC Microsoft SOL Server Setup x new ODBC data source will be created with the following configuration Microsoft SQL Server ODBC Driver Version 03 86 3959 Data Source Name 5 Data Source Description Server local Database Default Language Default Translate Character Data Yes Log Long Running Queries Log Driver Statistics Use Integrated Security Use Regional Settings Prepared Statements Option Drop temporary procedures on disconnect Use Failover Server Mo Use ANSI Quoted Identifiers Yes Use ANSI Null Paddings and warnings es Data Encryption Cancel
33. orms that are notin use including unused forms does nof fake info account fhe use of computed subforms Include Content columns in Excel sheet create TO columns with content reserve Da characters per content column Characters not regarded as 2 J content Comments J d E Convert Notes Data to SQL User Manual v1 3 2 Agent When running the agent print statements will update you with the status These print statements scheduled log nsf as well as manual status bar are useful to check if the agent is still processing 700 documents to process The agent will create 2 files in the specified Excel Output folder One is txt file the other is a formatted xls file The xls file will only be available if the system running the agent has Microsoft Excel installed INVENTORY _ NAMES 20100505145442 TXT Text Document 5 5 2010 14 55 EH INVENTORY X NAMES 20100505145442 xls 188 KB Microsoft Office Exc 5 5 2010 14 55 Convert Notes Data to SQL User Manual v1 3 Excel output file The Excel output may look something like this e Note that RICHTEXT item content is not dumped e Columns are automatically filtered Column Hits Has content and Elements show some extra comments on what is displayed in these columns 1 Form Field Field Type Hits Has content CN 1 Content 1019 POLICYREGISTRATION REGGRPS TEXT 2 2 Everyone
34. r fi 23 33 33 3MNSTANCE E d e E AS n E f Next gt Cancel Help Use the With SQL Server authentication using a login ID and password entered by the user radio button selection And enter the credentials in the fields beneath it Click Next Create a Data Source to SOL Server How should SQL Server verify the authenticity of the login ID C With Windows NT authentication using the network login With SOL Server authentication using login and password entered by the user To change the network library used to communicate with SUL Server click Client Configuration Client Configuration Connect ta SQL Server ta obtain default settings Far the d additional configuration options Login ID Password 7 lt Back Cancel Help Convert Notes Data to SQL User Manual v1 3 Use the default settings on all following dialogs until a Test Data Source dialog appears When the test succeeds the Data Source has been correctly setup and can be used from the application Create a New Data Source to SOL Server Attach database filename and drop the stored procedures when pou disconnect connected Use ANSI quoted identifiers avallable lt Back Cancel Help conversie F Ereate temporary stored procedures for prepared SAL statements When disconnect a
35. re exported as yymmddhhmmss According to ISO 8601 Extended Naam gt Grootte createBeroepsziekten_2_1tables sql 3kB SOQL bestand createBLOBtables sql 1 SQL bestand createBeroepsziekten 2 Ttables sql Kladblok Sel Bestand Bewerken Opmaak Beeld Help pee TABLE T_BERZIEK_REGISTRATIEFORMULIER_BEROEPSZIEKTEN REGBZ UNIQUEID NVARCHARC64 REGBZ RUNNO 30 REGBZ 2 AANDOENING NVARCHAR max REGBZ_BZ_AANDOENING_SPOOR NVARCHAR max REGBZ BZ AANDOENINGEN NVARCHAR REGBZ BZ AARD BEROEPSZIEKTE NVARCHAR max REGBZ BZ ACTIVITEIT NVARCHAR max REGBZ BZ ADVIES NVARCHAR max REGBZ BZ ADVIEZEN NVARCHAR max REGBZ BZ ARBODIENST NVARCHAR REGBZ 2 BEDRIJFSARTS NVARCHAR REGBZ BZ BEROEP NVARCHAR max REGBZ BZ BEROEP CODE NVARCHAR max REGBZ BZ BEROEPSZIEKTE NVARCHAR max REGBZ 2 CAS NVARCHAR max REGBZ BZ CAS CODE NVARCHAR max REGBZ_BZ_CASCODE NVARCHAR max REGBZ_BZ_CONTRACTNUMMER NVARCHAR max REGBZ_BZ_DATUM NVARCHAR 12 REGBZ BZ DATUM MELDING NCVB NVARCHAR 12 REGBZ BZ DATUM SIGNALERING NVARCHAR 12 REGBZ 2 DIAGNOSE NVARCHAR max REGBZ BZ ERNST ZIEKTE CODE NVARCHAR max REGBZ BZ ERNST ZIEKTE OMSCHRI JVING NVARCHAR max REGBZ BZ FUNCTIE NVARCHAR max REGBZ 2 GEBDATUM NVARCHAR 12 REGBZ 2 GESLACHT NVARCHAR max REGBZ 2 INGELICHT NVARCHAR max REGBZ BZ MANI
36. rted to MIME using the Lotus Domino Internal mechanism File attachments will be stored a separate BLOB table postfix table which can be linked to the original document using the form UNIQUEID key In this release internal and Reader fields are not exported Field Table dbo T BEROEPSZIEKTEN REGBZ LIMIQLL REGBZ RIINMO REGBZ BZ AA REGBZ AA REGBZ BZ AA REGBZ BZ AA REGBZ AC Objeck Explorer Connects gm 3 T El A 82 204 15 21YFIQASNOTES 1062 SQL Server 9 0 12577 1BOO47640F 1 FFI WARZPFIC EBje Gpb45NY p AMOgdqwRag n SV kztoH gIPu El Databases 040376 18066 1 v MFAggONnID 8 GOS 7IrdOBH 3O mLliI3G System Databases NS Hatabace 654 1 anjOlle O 5rws ZM lt HFOMT Gk u4ZHHPZ Oy T4frMYkHAMESID g3r ex lt T2NBF El CONVERSIE 0677067560870 1 h fawAlS DRIFbQsBrb D w sE amp BCs imuD xXjlkPeyulWi h aodoLbvFI MIsL Database Diagrams 1 gkkghhB htszoY PQOWWwOJFTQeB aRf DSSl4 Kzx amp zbgxi hw 4 sw j Tables ONT m rs ORES VERE 4CCOBCC3BFBE 1 vk2EyF uDr5T8 Udl b Yjs3xI amp LX3 ypw 5rgy wj L Nd C Synonyms DB7D8BESEBECO 1 Wh wXB yk QAIFIILFrOz vi1 MIuegDkIBIYzG d SSqw TFC
37. s gt Refresh Convert Notes Data to SQL User Manual v1 3 3 Script 17 Help User name Login name Certificate name Key name C Without login Default schema Schemas owned by this user Owned Schemas db accessadmin db backupoperator db datareader qnn nnne nennen nennen nennen nnne nnne nnne nennen nennen nent nnne nennen nnne t db ddladmin db denydatareader db denydatawriter Database role membership Role Members db accessadmin db backupoperator v db datarea db ddladmin db denydatareader db denydatawriter Convert Notes Data to SQL User Manual v1 3 Create an ODBC connection to log in to the SQL Server For the correct working of the application an ODBC connection must be made to the SQL system To do this on the Domino Server System open the ODBC Data Sources Administrator via Control Panel or as shown below 3 Programs E RapPOR gt Accessories GA Administrative Tools 2 Ep Data Sources ODBC Documents P Remote Assistance f Manage Your Server Microsoft SQL Server 2005 gt Y Settings Search Help and Support Run Log Off Administrator OWE Windows Server 2003 Standard Edition Shut Down 2 03 gt 2 Microsoft SQL Server Ma From the Administrator go to the System DSN tab and click add A
38. s lama m 37 Itemis Convert Notes Data to SQL User Manual v1 3 Convert Notes Data to SQL User Manual v1 3 4 The pump agent When all actions described in the paragraph above are performed you can enable the scheduled pump agent This agent maps all fields to various tables based on the database and form name in the specified SQL database The pump agent runs every 4 hours and will keep track of a run number and a checksum for the document e The run number will indicate whether the agent should process or skip this document during the next run when the agent has been aborted in an earlier run he checksum of the document is a value generated from the document s last modified date This value is logged on the 5DOC field in the Data Integrity Log For each document that is transported a Data Integrity Log database is created You will find these Log databases in notestosq dir LOG table postfix directory the server When the checksum value does not correspond to the value of the Notes database field the agent will add the updates to a the SQL table the old value is not overwritten For SQL it is clear this contains modifications to the earlier transported data Records with the highest absolute value in the run number will be the most recent deletions will be written with negative run numbers All fields except Rich Text are converted to text before transport Rich text will be conve
Download Pdf Manuals
Related Search