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 |
|
gogo7188
Starting Member
12 Posts |
 Posted - 2003-10-30 : 09:58:33
|
| We are going to start getting data (16 tables) from another government entity in the coming weeks. They are solely an Oracle shop and we are solely a SQL Server shop. In terms of ease of administration, etc. what is the best way to get data from Oracle into SQL Server? Should we get:1) CSV or fixed-length text dumps2) Get Oracle drivers for SQL box and then set up a job to get the data weekly, etc. I have heard about this...is it complex?3) Any other ideas???We have ZERO experience with Oracle in our office and the other office has a vendor do all their work. All thoughts/comments will be appreciated. Thanks, Chad |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-30 : 12:19:33
|
| I would ask for CSV or fixed-lenth text dumps so that you can run bcp on them to import the data. You should already have Oracle drivers on your SQL boxes, so you could go that way. If you went that way, you could use a linked server if you have a connection to them, you could also use DTS or even bcp using a data source.But I would go for number 1.Tara |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-10-30 : 13:28:55
|
| It is always better to request data as files from a system that you don't own - then the system owners are responsible for extracting the data, they will know the system and can schedule things to fit in with the processing of that system.A fixed width file will be easiest to deal with.see http://www.nigelrivett.net/ImportTextFiles.html for importing a number of text files.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Oracle Data in SQL Server 2000