User Manual - SQLBase to Oracle DB Conversion
Contents
1. MICROS FIDELIO GmbH 2008 Page 4 of 5 MICROS Fidelio micros FIDELIO Materials Control Europe Africa amp Middle East MC Login into the application and perform a database update and a reorganisation Data Base Update Materials Control File Edit System Help Data Base Update 5 ettings Database FBOR amp ORACLE 9 2 0 1 0 7 Version 11 56 Parameter File Jupd_db ini Start 856 Step 1 Reorganisation Step 2 Step 3 Restart the application MICROS FIDELIO GmbH 2008 Page 5 of 52. commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate fail safe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International Inc AMD Opteron the AMD logo and the AMD Opteron logo are trademarks or regi
3. a no vacha 20 2 alter table at_rezeptuntern modify rzt_info varchar2 2048 A ranp ange Gereesenrenrenennrneeneennene rr e EEETZEETZSETZEETETZETETEETZETTZETESETZSTTTSETZETTESETZEE TEE 3 alter table ABC add foreign key ART_IDO references ARTIKEL PPR Pers BLEITELTIETETTSTTETTEITETTERTETEPOPSETITTSTITERSELSLTSLTSETIETDEFETIORTORTBRTELIHILTBLTSTIRTERDIDLTELTILTTEL PULS TEILE TEDDESTISULSELTLFPULDOLSETSOLSELTELTELTULTETIELTOLTEHPEHPELTEITEITEITEITEITSEL BILDET DUTEEE eee eee 4 alter table ACC2IG add foreign key ACC_ID references ACCOUNTCLASS HoGecat eves EARBEELSEITSEETSEISE TTS EE IE A E E SEE A e EE tends sbaaee ee der ech cue A T EEEN P LIE E T ERES A EA E PNE IET EERGATIE E EET HIERHER HEHE TEHR rer 5 alter table ACC2IG add foreign key WW GAID references WARENGRUPPE POTTER hae susianvenvaqnannanans ssttuedobantoaiusnssinesrnas Givens tekst sents sbvansdhuedaieg RICH eeaaneayention sae dupenchiis sake T enmasheGenpnischockwe age taiavewenc duu TA A A A E alter table ADJUSTMENTS add foreign key ADT_ID references ADJUSTM REED DCCC ec eee aa 7 alter table AD SAR TPREIS add foreign key ADS _ ART references ADSVKA ren A HER HER HR SECHS EE MOSER HE HRS SEECHER HS HER PS HER MUS HER HE DEE HR Si A ei be RA E SHARE HOME RC EANA DEE HER HS HER EAEE J alter table ADSARTFREIS add foreign key EST_ID references KOSTST ares EEE ce ME PCN oN aa oe TE J alter table ANFZCAT add foreign key B_ID references ANFORD EPEETAN Du
4. User Manual Materials Control DB Conversion Oracle lt gt SQLBase micros FIDELIO Copyright by MICROS FIDELIO GmbH Europadamm 2 6 D 41460 Neuss Date August 22 2008 Page 1 of 5 MC MICROS Fidelio micros FIDELIO Materials Control Europe Africa amp Middle East Copyright 2015 Oracle and or its affiliates All rights reserved This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing If this software or related documentation is delivered to the U S Government or anyone licensing it on behalf of the U S Government then the following notice is applicable U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are
5. es E E A E T AA E BA EA PAT CEAT r ET DA TETE E EEA TT A E PETE ETE E E A E E E E 10 alter table ANFZCAT add foreign key ACAD references REC CATEGOR RZ P r eee eee eens 11 alter table ANFZKST add foreign key B_ID references ANFOARD ee Y STEERER cst HERNE MEERES EEE ERHEBEN HE TERN ES A EEEE 12 alter table ANFZKST add foreign key RST ID references KOSTST BA oie ET ELETTA iy dats aku buch Gav Geach Cob gee BNE AEt War DSS AEE E E a TREE ETHERNET HAAR FASER A A E T 13 alter table ANFORD add foreign key ABT _ID references ABTEIL ELLLPITPPLLER e E S T ETT TT A A a A E T E TITLE E AT TFLLERENEHLPLETTTETTTELTETTT ELLE TITENERELLITESTERLTEITETTETTTERTERTSLTTRTFLIETEILEFETSLLITEILETT 14 alter table ANFORD add foreign key BST_ID references BESTELLER Sema ib sit EE ENOTE EE EAEE hte ER SC PEE E DE He eat ened oad in patent LTE AGENTEN HET SEEN E ATE E 15 alter table ANFORD add foreign key B OWNER references BESTELLER Bere eee Seats SEE SER AEAEE HERR AEAEE aR REDE ER A ARE HEICHEE CHE HEETHECRERCHIE CHR AENEA AEAT iR alter tahle ANFORD add fareian keu EST D1 references KISTST a i l Load Differences ILL TI OCI FA ae f f j i lt gt j gt f 4 3 Process the scripts l Run Script Click on Processings ends with a commit Close window Y II UR DS SI DOP PS A PS US EI Pd tL Bal A BaP oad ARE Ba aaah Solin sale RR En 2 commit
6. n the section Target you must enter the following Database Name of the target database User Type in the ORACLE User name here e g FBORA Password Type in ORACLE User password e g MICROS SOURCE Database FE DATA C EJRO Conversion beret SYSADM Password DE Conversion Database FBOR amp User FEORA Passion je Materials Control Europe Africa amp Middle East Database Conversion 2 09 SOURCE 744 GET Database FEDATA Database FEDRA C EURO Conversion Hee OYGA Dhd le Password Password f DE Conversion Load Differences MICROS FIDELIO GmbH 2008 Page 3 of 5 MC MICROS Fidelio micros FIDELIO Materials Control Europe Africa amp Middle East Please do the following steps 1 Create the scripts Create Script Click on Create Sort If you receive following error message check your source and target settings Create script again x FEDATASYSADRT You have currently no connection to this database system Please check your settings or contact your system administrator 2 load the scripts l Load Script Click on E Database Conversion 7 09 i jol X SOURCE Database FE DATA Database Fen F EURO Conversion Heer Cc ATK User FBORA Passiword za Password je DB Conversion OK Number Command Conditic Load Script Of update besteller set bst_enc_passwd null where bst enc _parswds E11 ker tale ezetutem modiy
7. stered trademarks of Advanced Micro Devices UNIX is a registered trademark of The Open Group This software or hardware and documentation may provide access to or information about content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services unless otherwise set forth in an applicable agreement between you and Oracle Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services except as set forth in an applicable agreement between you and Oracle MICROS FIDELIO GmbH 2008 Page 2 of 5 MICROS Fidelio micros FIDELIO MC CONVERSION OF A DATABASE FROM SQLBASE TO ORACLE As first step you need to create the new tablespace and DB user in the Oracle instance Please use your standard scripts procedures for this In your installation directory you can find a file called DATABASE EXE Execute it Click the radio button DB Conversion In the section Source you must enter the following Database Name of the source database User Username for the db In case of SQLBase SYSADM in case of ORACLE type in the ORACLE User name here e g FBDATA Password incase of SQLBase SYSADM in case of ORACLE the ORACLE User password e g MICROS I
Download Pdf Manuals
Related Search