Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fresh
Starting Member
1 Post |
 Posted - 2003-08-15 : 13:08:46
|
| Hello,i have to move from access tables/queries into oracle 9any thoughts how to make this transaction?thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-15 : 19:17:07
|
| Ironically enough, if you had SQL Server available, you could use Data Transformation Services (DTS) to move the data directly form Access to Oracle. You should try downloading the 120-day evaluation version of SQL Server:http://www.microsoft.com/sql/evaluation/trial/default.aspYou'll get DTS and you'll be able to use it for the next 120 days.You'll be able to move table structures and data only, it will not copy indexes, primary or foreign keys, queries, forms or reports. You can re-create indexes, keys and constraints in Oracle afterwards, but you'll probably have to re-write the queries in order for them to work correctly. Oracle's SQL syntax is vastly different from Access, it's extremely unlikely they'll work as is.Oracle may have a data copy/conversion program available, I don't know for sure however. |
 |
|
|
|
|
|
copy tables/queries from MS access into Oracle 9