How can we migrate Oracle database to Microsoft Access?
Home > IT Answers > Oracle > How can we migrate Oracle database to Microso...
Vsrameshkumar02
5 pts.
0
Q:
How can we migrate Oracle database to Microsoft Access?
Oracle import/export, Microsoft Access import/export, Oracle migration, Microsoft Access, Database migration
oracle to ms access
ASKED: Mar 29 2009  9:32 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Wrobinson
5610 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You may want to review some of the following references http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx.
Last Answered: Mar 29 2009  1:57 PM GMT by Wrobinson   5610 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Wrobinson   5610 pts.  |   Mar 29 2009  1:56PM GMT

This is an interesting question. Microsoft Access is not an enterprise database solution; it is really intended for small stand alone databases and rapid application development. Therefore, depending on your requirements, it may not be the right solution. You may want to look at Microsoft SQL Server instead.

 

Carlosdl   29855 pts.  |   Mar 30 2009  2:10PM GMT

It could be interesting and useful to know the reasons why you want to do this migration.

 

Prufrock   20 pts.  |   Mar 31 2009  10:29PM GMT

Access is an application development tool and is in no way a replacement for an Oracle DBMS. To get a better answer I think you need to give a lot more explanation about what you are trying to achieve.

Have you considered that you can link an Oracle database to Access via ODBC so that Access could be used as a front end to the Oracle database?

 
0