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 |
|
helixpoint
Constraint Violating Yak Guru
291 Posts |
 Posted - 2010-07-12 : 12:40:18
|
| They are bringing in an Aplication that has a SQL backend. I need to do a one time data dump from an Oracle databse to the SQL DB. The fields are quite different and they will need to be mapped. I have been put in charge of this and I am not the best at BD stuff. What is the best procedure to do this. Should I use SSIS...Link Server...Oracle gateway...Or just write a small app and connect directly to the Oracle and SQL databases. There is a ton or records.DaveHelixpoint Web Developmenthttp://www.helixpoint.com |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-12 : 12:55:47
|
| For a one time pump, I'll use the import/export wizard. Unless the remapping is dramatic, in which case writing an SSIS package is the way to go. |
 |
|
|
helixpoint
Constraint Violating Yak Guru
291 Posts |
Posted - 2010-07-12 : 13:06:45
|
| The problem is I am not to familiar with using SSIS. Do you know of an example that is doing a similar job?DaveHelixpoint Web Developmenthttp://www.helixpoint.com |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-12 : 14:38:23
|
| use the import/export wizard and let it do a simple import. have it save the code, then you can look at it and get a good idea of what to do. |
|
|
|
|
|
|
From Oracle to SQL