Hi
Does anyone know, how to migrate mdb materials database to the Oracle database?
(sorry for bad English language & first time post)
Thank You
Peter.
motylek: Hi Does anyone know, how to migrate mdb materials database to the Oracle database? (sorry for bad English language & first time post) Thank You Peter.
No, we do not have any experience with this task
motylek: Does anyone know, how to migrate mdb materials database to the Oracle database?
Migration means - copying data to a new database. You have to create a necessary fields in a Oracel database and then copy data from Access to Oracle. I think it's not a problem.
Have you asked your distributor for help?
Pozdrawiam / Best regardsArek Jaskulski INFORMIK Polska / Poland
To migrate/Import a database to Oracle you need to do:
1. Create a new Oracle database if you don’t have one you want to use.
2. Create tables that match the tables you want to migrate for you Access database
3. Install Oracle Client and Oracle OLE DB provider on your PC
4. Connect PC|SCHEMATIC to your Oracle database. To connect PC|SCHEMATIC to Oracle database you need an udl file with the connection settings. You can create udl files with PC|SCHEMATIC Database program.
a. Start PC|SCHEMATIC Database
b. Choose File, New and select “Microsoft Data Link (udl file)
c. Select the Microsoft OLE DB Provider for Oracle and click next
d. Set the Connection parameter for You oracle database and click Test to verify connection
e. Click Ok to save the connection in a udl file
5. You can now use the PC|SCHEMATIC Database Import function to import your Access database tables into your Oracle database tables.
6. Connect PC|SCHEMATIC Automation to your new Oracle Database
a. Start PC|SCHEMATIC Automation
b. Click on Settings, Database
c. Click on Select Database and choose the udl file you saved in step 4.e
d. Select the table that holds you component data
e. Click on Component Data to configure Field Setup, Compoent Data, Components Search, Database Menu and url Links.
Henrik Poulsen PC|SCHEMATIC A/S