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 |
|
neo_6053
Starting Member
24 Posts |
 Posted - 2008-11-17 : 08:35:22
|
| I'm using SSMA. But i dont want to migrate the index, trigger , stored procc or whatsoever. i just want the data. Because in fact i already have a SQL server version of database containing all the table schema, stored procedure, views and others. (We write query for both while in development) So i just need the data to be migrate. What is the best way to do it ? i've tried using excel, csv but the table is too huge (1 million record) and also the problem with date format.when i use SSMA, if i directly migrate data without convert schema, it gives me error "The given key was not present in the dictionary." i dun want to follow the oracle table schema since i already own the SQL version. so, what can i do? any better tools?i've also tried to wirte code using sqlbulkcopy but seems it cannot migrate date column. |
|
|
neo_6053
Starting Member
24 Posts |
Posted - 2008-11-17 : 21:01:12
|
| hihi, can someone help me ? |
 |
|
|
|
|
|
How to migrate from oracle to SQL?