Hello.
I’m trying to achieve or understand how to accomplish a database transformation from access to oracle.
We currently have a large database consisting of about 125000 records plus, which provides all information on our ASP web driven website. There has been some cause for concern, if access is going to hold up with more and more records being constantly added to the database. It has been decided to migrate over to oracle; however we are unsure on the scale of this operation or difficulty.
Required
• All data and tables would need to be migrated
• All relationships transferred
We have stuck a brick wall as to what to do, and really are looking for some
guidelines or pointer to help complete this transformation as quick as poss
ible.
Side Notes
• We do have some oracle experienced personnel within out team; however they not clear on how to achieve the access to oracle transformation.
• Oracle is installed and setup on our servers ready for the transformation
Screen Shots
Tables
Relationships
I’m not sure if they help any, however you can see it is a slightly complex
database from these images, which may give you an idea of the scale.
Any feedback or help would be brilliant.
Thanks MoFish  |
