Click here to Skip to main content
15,946,988 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i want to convert my access database in SQL and Oracle 10g database please
help. too many records i cannot type again. m selecting a column but is not pasting in sql table's column
Posted

1 solution

I would do this in two steps:
1. Migrate the Access database to Sql Server
2. Copy the data from Sql Server to Oracle

In order to migrate the Access database to Sql Server you can download SSMA[^].

After the migration, you can establish for example a Linked Server to Sql Server and copy the data from source Sql Server to target Oracle. For more information about linked servers, see Linked Servers[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900