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 |
|
koshtipk
Starting Member
2 Posts |
 Posted - 2008-01-09 : 02:41:47
|
| Hi, I want the tutorial for developing Integration Service for copying the database from Oracle 9i to SQL Server 2005. If anybody knows then pls give me the steps.. Thanx in advance. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-01-09 : 03:13:16
|
| The only tricky bit is getting the oracle connection - you will need to install the Oracle client and tns name then it should be fairly easy.You might have a few problems with datatypes - invalid dates (oracle allows earlier dates than sql server) and tables benig created with innappropriate types if you let ssis do it for you but you'll just have to check that when it runs.==========================================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. |
 |
|
|
|
|
|
Tutorial for DTS from Oracle to SQL Server 2005